I would suggest doing a
pg_dump > filename
then save that to disk, email it, ftp, whatever to the destination server, and
createdb databaseName
psql databaseName < filename
-Aaron
Can someone please tell me the easiest method for moving a database from one server to another?
Pleaes be explicit, I am in the Novice group for a reason.
Kent