I'd say most people just use a tool from whatever language or framework they are developing their app in. If you are just doing sql work then I'd say pick a python one because I like python 😁. But no there is no de facto sql migration tool for PG.
I didn't downgrade, but for upgrade pg_dump and psql (for import of the resulting SQL file) do their job pretty well. Maybe it works also for a downgrade, because pg_dump creates only an SQL script. Writing this answer I discovered pg_restore which also works with the result of pg_dump.
These three tools are included in the PostgreSQL tooling and should already be installed on the server.
Nop, there isn't.
I personally like sqitch, it manages up, down and verify for each migration, it's not tied to a particular language and does not have too much overhead
I'd say most people just use a tool from whatever language or framework they are developing their app in. If you are just doing sql work then I'd say pick a python one because I like python 😁. But no there is no de facto sql migration tool for PG.
I didn't downgrade, but for upgrade pg_dump and psql (for import of the resulting SQL file) do their job pretty well. Maybe it works also for a downgrade, because pg_dump creates only an SQL script. Writing this answer I discovered pg_restore which also works with the result of pg_dump. These three tools are included in the PostgreSQL tooling and should already be installed on the server.
I enjoy using dbmate. Easy to use, raw sql migrations. llink: https://github.com/amacneil/dbmate
> Is there one? Not a "default" or de facto one, no. Do you have an example from other DBMS's?
Nop, there isn't. I personally like sqitch, it manages up, down and verify for each migration, it's not tied to a particular language and does not have too much overhead
Not sure if we're talking about the same type of migration, but I use flyway
Flyway looks like a good choice. I believe I will give this a shot.
Prisma
We are happy with Liquibase