On Thu, Apr 16, 2015 at 06:14:20PM -0400, Octavi Fors wrote:
> at first glance, option 1) seems to me simpler. But does it guarantee
> server version upgrade compatibility?
Yes. Use the pg_dump from the later postgres, which can read old
versions and generate any output needed for the new version. It's
just like any other pg_dump otherwise.
> Could you/someone please provide an example of commands which I could use?
Usually pg_dump [connection options] databasename | psql [connection
options] databasename
For instance, if you wanted from the new machine to dump egdb from the
old machine and restore locally, you could do
pg_dump -U postgres -h 192.0.2.1 -C egdb | psql -U postgres
I recommend reading the pg_dump (and if you like, pg_dumpall) manuals
before proceeding.
A
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca