On 10/24/07, smiley2211 <smiley2211(at)yahoo(dot)com> 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