Hi,

I have two servers running pgsql.  Is there a command to transfer the
databases
between them?

Craig May

Enth Dimension
http://www.enthdimension.com.au


Sun, 18 Jun 2000 09:07:07 +1000
Craig May <craig.may@s2.enthdimension.com.au>
Database Transfer
Craig May writes:

> I have two servers running pgsql.  Is there a command to transfer the
> databases
> between them?

pg_dump and psql. "Back up" one database and "restore" it on the other
server. Don't even think about moving files around. :)

-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Sun, 18 Jun 2000 16:24:43 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: Database Transfer
I have an interest in this topic ...

I am looking to do "real time" updates of a data base on two different
servers, with one acting as a master and the other acting as a slave.  In
the realm of Oracle, I believe it is called "replication".

 From what I have read, there is no such feature in pgsql.  Can somebody
confirm this?

Thanks,
Kate Collins

Peter Eisentraut wrote:

> Craig May writes:
>
> > I have two servers running pgsql.  Is there a command to transfer the
> > databases
> > between them?
>
> pg_dump and psql. "Back up" one database and "restore" it on the other
> server. Don't even think about moving files around. :)
>
> --
> Peter Eisentraut                  Sernanders vï¿½g 10:115
> peter_e@gmx.net                   75262 Uppsala
> http://yi.org/peter-e/            Sweden

--
=================================================
Katherine (Kate) L. Collins
Senior Software Engineer/Meteorologist
Weather Services International (WSI Corporation)
4 Federal Street
Billerica, MA 01821
EMAIL:  klcollins@wsicorp.com
PHONE: (978) 670-5110
FAX: (978) 670-5100
http://www.intellicast.com



Mon, 19 Jun 2000 04:49:01 -0400
Kate Collins <klcollins@wsicorp.com>
Re: Database Transfer
Ciao Kate Collins, on 19-Jun-00 as written on pgsl-sql mailing list:

> I have an interest in this topic ...

> I am looking to do "real time" updates of a data base on two different
> servers, with one acting as a master and the other acting as a slave.  In
> the realm of Oracle, I believe it is called "replication".

I don't know if there is someone available to discuss about:
how would be possible the implementation of "replication" feature in
PostgreSQL?


Bye,               \fer


Tue, 20 Jun 2000 16:19:22 +0100
Ferruccio Zamuner <nonsolosoft@diff.org>
Re: [SQL] Database Transfer