Postgres Pro
Downloads
Home   >   mailing lists

Automating Backup & Restore - Mailing list pgsql-general

From smiley2211
Subject Automating Backup & Restore
Date
Msg-id 13384762.post@talk.nabble.com
Whole thread Raw
Responses Re: Automating Backup & Restore  (Jan de Visser <jdevisser@digitalfairway.com>)
Re: Automating Backup & Restor  ("Mikko Partio" <mpartio@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Andreas Neumann"
Date:
Subject: Constraints involving a system table
Next
From: Jan de Visser
Date:
Subject: Re: 8.3b1 in production?