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

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

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