Re: database A to database B

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: "Ing(dot) Jhon Carrillo" <jdigital(at)cantv(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: database A to database B
Date: 2005-05-18 14:42:07
Message-ID: 1116427327.31821.12.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 2005-05-18 at 08:27, Ing. Jhon Carrillo wrote:
> Hi all,
>
> I have two postgresql 7.4 (Linux) servers:
>
> Server A: it has a original database.
> Server B: it doesn't have nothing.
>
>
> I need to transfer the database/server A to database/server B through the
> some command directly.

You can do something like this:

pg_dumpall -h servera|psql -h serverb

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Pallav Kalva 2005-05-18 14:49:31 Re: SQL logging (log_min_duration_statement) not working
Previous Message John DeSoi 2005-05-18 14:40:34 Re: database A to database B