Automating Backup & Restore

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

Any hints or tips are welcomed...

Thanks...Michelle.
--
View this message in context: http://www.nabble.com/Automating-Backup---Restore-tf4684052.html#a13384762
Sent from the PostgreSQL - general mailing list archive at Nabble.com.