Re: database A to database B - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: database A to database B
Date
Msg-id 1116427327.31821.12.camel@state.g2switchworks.com
Whole thread Raw
In response to database A to database B  ("Ing. Jhon Carrillo" <jdigital@cantv.net>)
List 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

pgsql-admin by date:

Previous
From: John DeSoi
Date:
Subject: Re: database A to database B
Next
From: Pallav Kalva
Date:
Subject: Re: SQL logging (log_min_duration_statement) not working