Re: Using postgres.log file for replication

If you want the same thing in real time look into pgpool II

On Thu, Nov 27, 2008 at 10:28 AM, Ioana Danes <ioanasoftware(at)yahoo(dot)ca> wrote:
> I know there are some limitations abut it:
> - copy statements cannot be executed,
> - the use of now() function
> - even database restore scripts I don't want to be replicated
> but these are not a problem for me because I don't use them in the application...
>
>
>
> --- On Thu, 11/27/08, Csaba Nagy <nagy(at)ecircle-ag(dot)com> wrote:
>
>> From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
>> Subject: Re: [GENERAL] Using postgres.log file for replication
>> To: ioanasoftware(at)yahoo(dot)ca
>> Cc: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
>> Received: Thursday, November 27, 2008, 12:24 PM
>> 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.
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list
>> (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
> __________________________________________________________________
> Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now at
> http://ca.toolbar.yahoo.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
When fascism comes to America, it will be draped in a flag and
carrying a cross - Sinclair Lewis