Skip site navigation (1) Skip section navigation (2)

Re: Using postgres.log file for replication

From: Ioana Danes <ioanasoftware(at)yahoo(dot)ca>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using postgres.log file for replication
Date: 2008-11-27 17:28:29
Message-ID: 391177.55922.qm@web45101.mail.sp1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
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.


In response to

Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2008-11-27 17:34:06
Subject: Re: Using postgres.log file for replication
Previous:From: Csaba NagyDate: 2008-11-27 17:24:51
Subject: Re: Using postgres.log file for replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group