Re: backup another server

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Edwin Quijada <listas_quijada(at)hotmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: backup another server
Date: 2003-10-29 17:49:34
Message-ID: Pine.LNX.4.33.0310291049080.21847-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 29 Oct 2003, Edwin Quijada wrote:

>
>
>
> Hi!!
> I wanna take a whole database running in a box1 pg7.3.4 and moving to
> another box2 with 7.3.4 too.
> There is a fast way to do that??
> Which??/

The way I do it is:

pg_dumpall -h source_machine |psql -h dest_machine

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Hatcher 2003-10-29 17:56:55 dump schema schema only?
Previous Message Edwin Quijada 2003-10-29 17:47:27 Trigger delete