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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
