From: Poul L. Christiansen <poulc@cs.auc.dk>
To: Adam Lang <aalang@rutgersinsurance.com>
Cc: PGSQL General <pgsql-general@postgresql.org>
Subject: Re: replication
Date: Thu, 21 Sep 2000 15:18:12 +0100
Message-ID: <39CA18A4.80D12421@cs.auc.dk> (raw)
References: <001d01c023ca$e37d9cc0$330a0a0a@Adam>
Adam Lang wrote:
>
> Are there any type of replication features in postgresql 7.0?
>
> I would like it where two databases have the same structure, but say at
> midnight every night Database 1 synchs up database 2.
>
> Granted, I could always write code to do that, but it wouldn't be very
> sophisticated. (If I coded it, would do something like find rows in table
> 1 which aren't in the second database, append them database two, same with
> the second table, etc.)
And you would also have to check which records have been modified and
replicate them.
You are not the first person to ask for this feature and it is on the
TODO list:
http://www.postgresql.org/docs/pgsql/doc/TODO.detail/replication
but it is categorized under "exotic features", so I don't know when
we'll see it implemented :(
But I think www.psql.com are working on replication right now.
Poul L. Christiansen
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: poulc@cs.auc.dk, aalang@rutgersinsurance.com
Subject: Re: replication
In-Reply-To: <39CA18A4.80D12421@cs.auc.dk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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