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@xxxxxxxx> 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@xxxxxxxxxxxxxx> wrote: > >> From: Csaba Nagy <nagy@xxxxxxxxxxxxxx> >> Subject: Re: Using postgres.log file for replication >> To: ioanasoftware@xxxxxxxx >> Cc: "PostgreSQL General" <pgsql-general@xxxxxxxxxxxxxx> >> 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@xxxxxxxxxxxxxx) >> 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@xxxxxxxxxxxxxx) > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
