Comment on What if we treated Postgres like SQLite?parentComments−oulipo211moSo the alternative would be to just pg_dump / pg_restore the content? Is it an issue?−eirikbakke11moThat is the correct way to do it for PostgreSQL.It does rule out some common SQLite use cases, such as using the database for app persistence. The app would never be able to upgrade the major version of PostgreSQL, unless it bundled PostgreSQL binaries for every major version ever used.−chucky_z11moIf it's more than even like 10GB this is going to take _awhile_.I love the pg_* commands but they ain't exactly the speediest things around.−amtamt11moLogical replication would be a good option, with temporarily extra hardware added.
Comments
So the alternative would be to just pg_dump / pg_restore the content? Is it an issue?
That is the correct way to do it for PostgreSQL.
It does rule out some common SQLite use cases, such as using the database for app persistence. The app would never be able to upgrade the major version of PostgreSQL, unless it bundled PostgreSQL binaries for every major version ever used.
If it's more than even like 10GB this is going to take _awhile_.
I love the pg_* commands but they ain't exactly the speediest things around.
Logical replication would be a good option, with temporarily extra hardware added.