| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Oleg Lebedev" <oleg(dot)lebedev(at)waterford(dot)org>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: FW: Merging databases |
| Date: | 2002-08-22 09:21:27 |
| Message-ID: | 200208221021.28666.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday 21 Aug 2002 11:07 pm, Oleg Lebedev wrote:
> I wonder what would be a good way to merge data from two databases with
> same desing and schemas.
Do a search on "replication" in the mailing list archives. There are various
projects to do this at various stages of progress. See the "contrib"
directory if you have installed from source.
> What would be an optimal or a typical way to do this? Can I
> access a remote database running Postgres 7.2.1?
> thanks.
Typically with a Perl/Python client application. It either talks to both
databases simultaneously or takes responsibility for one end only. Whatever
solution you decide upon, take care with 2 things:
1. How am I handling deletion of data?
2. What happens if both sites update the same information? Is one always
right? Do individual records have owners? Does the user have to get involved?
- Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas Paymal | 2002-08-22 09:58:06 | like with '\' |
| Previous Message | Andrew Bartley | 2002-08-22 08:42:01 | pg_statistic_relid_att_index |