On 10/2/14, 7:28 AM, Robert Haas wrote:
On Thu, Oct 2, 2014 at 4:49 AM, Heikki Linnakangas
<hlinnakan...@vmware.com> wrote:
>An origin column in the table itself helps tremendously to debug issues with
>the replication system. In many if not most scenarios, I think you'd want to
>have that extra column, even if it's not strictly required.
I like a lot of what you wrote here, but I strongly disagree with this
part. A good replication solution shouldn't require changes to the
objects being replicated.
I agree that asking users to modify objects is bad, but I also think that if
you do have records coming into one table from multiple sources then you will
need to know what system they originated on.
Maybe some sort of "hidden" column would work here? That means users don't need
to modify anything (including anything doing SELECT *), but the data is there.
As for space concerns I think the answer there is to somehow normalize the
identifiers themselves. That has the added benefit of allowing a rename of a
source to propagate to all the data already replicated from that source.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
