Re: Using postgres.log file for replication

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: ioanasoftware(at)yahoo(dot)ca
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using postgres.log file for replication
Date: 2008-11-27 17:24:51
Message-ID: 1227806691.16671.63.camel@PCD12478
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2008-11-27 at 09:20 -0800, Ioana Danes wrote:
> I've been wondering if anybody tried to use the postgresql csv log file to replicate sql statements.
> I've been looking into it in the past days and after a brief testing it doesn't look bad at all...

Try to execute something like:

UPDATE some_table SET some_timestamp_field = now();

The replica is now different than the master :-)

Cheers,
Csaba.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ioana Danes 2008-11-27 17:28:29 Re: Using postgres.log file for replication
Previous Message Ioana Danes 2008-11-27 17:20:24 Using postgres.log file for replication