I am trying to move a database from my old server to a new server. Any help would be appreciated.
+1
A:
Dump it on the first server and restore it on the second, using either the command line tools or something loke pgAdmin.
Kees de Kooter
2010-08-17 02:24:50
thanks for the answer, i will give that a try
2010-08-17 02:37:05
+1
A:
Just pipe a dump from the old server into the new one:
pg_dump -h 172.26.76.100 -p 5432 -U username your_db | psql -h localhost -p 5432 -U username your_db
Replace the ip addresses and there you go. If you're using different versions of PostgreSQL, make sure you use pg_dump and psql from the latest version.
Frank Heikens
2010-08-17 06:12:53
pg_dumpall will get everything. He should make sure he uses roles that are superusers to get everything.
mikelikespie
2010-08-18 10:04:08