On 10/24/07, smiley2211 <[EMAIL PROTECTED]> wrote: > > > 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
