Postgres updates are definitely a pain. MySQL is usually just a matter of upgrad... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

Macha on March 15, 2024 | parent | context | favorite | on: Postgres is eating the database world

Postgres updates are definitely a pain. MySQL is usually just a matter of upgrading the package and restarting the server for the projects I run, but postgres is a full dump and import process.

scientist4397 on March 15, 2024 [–]

I manage many PostgreSQL databases, the only time it was a pain, it was due to PostGIS upgrade but not the postgresql cluster itself…

You don’t need to dump and re import the database since a long long time…

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact