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