John R Pierce wrote:
Roderick A. Anderson wrote:
<snip />
make sure pg_hba.conf on the old machine allows you to connect from the
new machine's IP address as the user postgres (this may require setting
a database password for the postgres user on the old machine if the
'host' authentication method so specifies), then from the new machine,
after doing an initdb and starting the new version of postgres, and
while logged on as the unix postgres user...
Been there done that and own may tee-shirts. :-)
The old system has been running for so long without any significant
issues I've forgotten if there ever was a password. I'm hoping
adding/changing the postgres password doesn't break anything else.
No screams so far!
pg_dumpall -h oldmachine -U postgres | psql
Well, no pg_dumpall going to happen -- only pg_dump. The whole cluster
isn't going to the new machine.
But my command line from my workstation goes like this.
pg_dump -U postgres -h db.domain.tld -D -C -f Desktop/rt2.sql rt2
\\||/
Rod
--
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
