Re: Recording insert, updates, and deletes

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Andy Dale <andy(dot)dale(at)gmail(dot)com>
Cc: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Recording insert, updates, and deletes
Date: 2007-01-10 19:03:42
Message-ID: 1168455822.20602.191.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2007-01-10 at 12:37, Andy Dale wrote:
> Hi Brad,
>
> If i have to create a separate slony replication set, then i cannot do
> it this way (i cannot and do not want to have a master-slave(s)
> architecture)
>
> Andy
>
> On 10/01/07, Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> wrote:
> On Wed, 2007-01-10 at 16:51 +0100, Andy Dale wrote:
>
> > If anyone can help or offer advice on how to achieve my
> objective it
> > would be greatly appreciated.
>
> Slony log shipping will do this

I've lost the OP, but look in the contrib/spi directory for something
designed to do auditing of inserts / deletes etc...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-01-10 20:08:41 Re: Trying to load MySQL data
Previous Message Gene 2007-01-10 19:02:00 replication advice needed