Thread

1. Database Transfer

   Craig May <craig.may@s2.enthdimension.com.au> — 2000-06-17T23:07:07Z

   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
   
   
   

2. Re: Database Transfer

   Peter Eisentraut <peter_e@gmx.net> — 2000-06-18T14:24:43Z

   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
   
   
   

3. Re: Database Transfer

   Kate Collins <klcollins@wsicorp.com> — 2000-06-19T08:49:01Z

   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
   
   
   
   

4. Re: [SQL] Database Transfer

   Ferruccio Zamuner <nonsolosoft@diff.org> — 2000-06-20T15:19:22Z

   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