From: | Kate Collins <klcollins(at)wsicorp(dot)com> |
---|---|
To: | PGSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Database Transfer |
Date: | 2000-06-19 08:49:01 |
Message-ID: | 394DDE7D.87B069B6@wsicorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers 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".
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(at)gmx(dot)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(at)wsicorp(dot)com
PHONE: (978) 670-5110
FAX: (978) 670-5100
http://www.intellicast.com
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB | 2000-06-19 11:16:14 | AW: Big 7.1 open items |
Previous Message | Tom Lane | 2000-06-19 06:55:33 | Re: PROBLEM on SOLARIS |
From | Date | Subject | |
---|---|---|---|
Next Message | Tulassay Zsolt | 2000-06-19 14:24:22 | the day after... |
Previous Message | rocael | 2000-06-18 18:38:49 | capacity of copy command?? |