pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database Transfer
4+ messages / 4 participants
[nested] [flat]

* Database Transfer
@ 2000-06-17 23:07  Craig May <craig.may@s2.enthdimension.com.au>
  0 siblings, 1 reply; 4+ messages in thread

From: Craig May @ 2000-06-17 23:07 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Database Transfer
@ 2000-06-18 14:24  Peter Eisentraut <peter_e@gmx.net>
  parent: Craig May <craig.may@s2.enthdimension.com.au>
  0 siblings, 1 reply; 4+ messages in thread

From: Peter Eisentraut @ 2000-06-18 14:24 UTC (permalink / raw)
  To: Craig May <craig.may@s2.enthdimension.com.au>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Database Transfer
@ 2000-06-19 08:49  Kate Collins <klcollins@wsicorp.com>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Kate Collins @ 2000-06-19 08:49 UTC (permalink / raw)
  To: pgsql-sql

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".



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Database Transfer
@ 2000-06-20 15:19  Ferruccio Zamuner <nonsolosoft@diff.org>
  parent: Kate Collins <klcollins@wsicorp.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Ferruccio Zamuner @ 2000-06-20 15:19 UTC (permalink / raw)
  To: pgsql-hackers@hub.org

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2000-06-20 15:19 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-17 23:07 Database Transfer Craig May <craig.may@s2.enthdimension.com.au>
2000-06-18 14:24 ` Peter Eisentraut <peter_e@gmx.net>
2000-06-19 08:49   ` Kate Collins <klcollins@wsicorp.com>
2000-06-20 15:19     ` Ferruccio Zamuner <nonsolosoft@diff.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox