Re: Automating Backup & Restore

From: Jan de Visser <jdevisser(at)digitalfairway(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: smiley2211 <smiley2211(at)yahoo(dot)com>
Subject: Re: Automating Backup & Restore
Date: 2007-10-24 14:50:57
Message-ID: 200710241050.57444.jdevisser@digitalfairway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)digitalfairway(dot)com

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ahnf 2007-10-24 15:04:52 jdbc: ERROR transaction is read-only
Previous Message smiley2211 2007-10-24 14:39:23 Automating Backup & Restore