On 10/24/07, smiley2211 <smiley2211@xxxxxxxxx> wrote:
server1$ pg_dump mydb | psql -h server2 -d mydb
Regards
M
Hello all,
Does someone have a script that backups a database from one server and
restores it to another server??? I am NEW to Postgresql so I am starting
from scratch...
so, in essence - what I want to do is (I CURRENTLY DO THIS MANUALLY):
Server1 (IS IT POSSIBLE TO DUMP DIRECTLY TO SERVER2??)
pg_dump > filename.dmp
scp filename.dmp to SERVER2
Server2
psql -d mydb -f filename.dmp
vacuum
reindex
server1$ pg_dump mydb | psql -h server2 -d mydb
Regards
M
