rootninja

For getting a copy of a live system’s postgres databases onto a development platform, it’s easiest to just dump the whole thing and restore it on the dev machine.

I don’t want just one or two databases, or even just all the data, I want everything to match exactly.

$ pg_dumpall > ~/data.dump

To load it onto the new machine (restore), I just copy it over to the remote machine or walk it over on a thumbdrive.

$ sudo su postgres -
$ psql -f data.dump postgres