Postgres Pro
Downloads
Home   >   mailing lists

Re: Automating Backup & Restore - Mailing list pgsql-general

From Jan de Visser
Subject Re: Automating Backup & Restore
Date
Msg-id 200710241050.57444.jdevisser@digitalfairway.com
Whole thread Raw
In response to Automating Backup & Restore  (smiley2211 <smiley2211@yahoo.com>)
Responses Re: Automating Backup & Restore  (brian <brian@zijn-digital.com>)
List pgsql-general
Tree view 
On Wednesday 24 October 2007 10:39:23 smiley2211 wrote:
> 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...

$ pg_dump -h server1 database | psql -h server2

jan

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------

pgsql-general by date:

Previous
From: Jan de Visser
Date:
Subject: Re: 8.3b1 in production?
Next
From: ahnf
Date:
Subject: jdbc: ERROR transaction is read-only