Tag Info

New answers tagged

7

This answer applies to modifying the PostgreSQL source code by applying a "diff" or "patch". It's not about installing minor version updates; to do that, just download and run the installer. To alter the PostgreSQL server its self or its procedural language runtimes, you will generally need to recompile PostgreSQL from scratch. On Windows that's a bit of ...


0

It really depends how big, complicated and active your database is. Bear in mind that while you are making schema changes, many of the tables will be read-only or completely inaccessible until the changes are completed. Also bear in mind that the reverse is true - your schema changes will need to acquire exclusive locks on entire tables and possibly all ...


0

What I do is to build and test a script with the changes in a development server. It must upgrade the db in a totally automated and reproducible way. That includes running it with the same user with the same permissions with which it will be run in the production server. That said this question is too broad and should be asked in ...


0

Physical: "Differences between the primary server(s) and the standby server(s) are always supported as long as the Oracle software installed on all servers is of the same Oracle Platform as defined above, is certified to run on each server, and is the same Oracle Database Release and Patch Set." Logical: "Differences between the primary server(s) and the ...


1

The simplest approach is to simply use pg_dumpall -f cluster.dump, then restore with psql -f cluster.dump on the new host. Slightly more sophisticated is to dump globals, then dump each DB separately: pg_dumpall --globals-only > globals.sql psql -qAt -c 'SELECT datname FROM pg_database WHERE NOT datistemplate;' -0 |\ xargs -0 -i pg_dump -Fc -f ...


0

It sounds like the best thing is to do a full export/import of your database. 10GB is not a big database (relatively) and shouldn't be problematic. Export with pg_dump and import with psql.



Top 50 recent answers are included