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
-----Original Message-----
From: Kent Rigby [mailto:kent(dot)rigby(at)att(dot)net]
Sent: Tuesday, December 24, 2002 12:54 PM
To: PGSQL Novice List
Subject: [NOVICE] Moving a database
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