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

Re: Using postgres.log file for replication

From: Ioana Danes <ioanasoftware(at)yahoo(dot)ca>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Csaba Nagy <nagy(at)ecircle-ag(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using postgres.log file for replication
Date: 2008-11-28 16:10:03
Message-ID: 306471.67104.qm@web45112.mail.sp1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi Scott,

Thanks for the replay, 

It is almost impossible to use any of the replication tools mostly because the 2 dbs are not on the same network (live and testing environments)... I don't intend to use this for high availability. I am using Sequoia and PITR for that...

I only intend to use it to replicate a live database for testing purposes on another network... 

Thanks again,
Ioana

--- On Thu, 11/27/08, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

> From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> Subject: Re: [GENERAL] Using postgres.log file for replication
> To: ioanasoftware(at)yahoo(dot)ca
> Cc: "Csaba Nagy" <nagy(at)ecircle-ag(dot)com>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
> Received: Thursday, November 27, 2008, 1:53 PM
> Then you might wanna look at slony.  We use it and it's
> quite stable
> and reliable, and if the slave can't keep up it's
> no big deal to the
> master.
> 
> On Thu, Nov 27, 2008 at 11:33 AM, Ioana Danes
> <ioanasoftware(at)yahoo(dot)ca> wrote:
> > Thanks for the tip Scott but am looking for an
> asynchronous replication that does not interfere with the
> performance of the application. Also I don't necessary
> need the latest changes to be applied right away. Even a day
> difference is enough...
> >
> > Thanks a lot,
> > Ioana
> > --- On Thu, 11/27/08, Scott Marlowe
> <scott(dot)marlowe(at)gmail(dot)com> wrote:
> >
> >> From: Scott Marlowe
> <scott(dot)marlowe(at)gmail(dot)com>
> >> Subject: Re: [GENERAL] Using postgres.log file for
> replication
> >> To: ioanasoftware(at)yahoo(dot)ca
> >> Cc: "Csaba Nagy"
> <nagy(at)ecircle-ag(dot)com>, "PostgreSQL General"
> <pgsql-general(at)postgresql(dot)org>
> >> Received: Thursday, November 27, 2008, 12:34 PM
> >> 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
> >>
> >> --
> >> 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
> >
> >
> >     
> __________________________________________________________________
> > Instant Messaging, free SMS, sharing photos and
> more... Try the new Yahoo! Canada Messenger at
> http://ca.beta.messenger.yahoo.com/
> >
> >
> 
> 
> 
> -- 
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


      __________________________________________________________________
Connect with friends from any web browser - no download required. Try the new Yahoo! Canada Messenger for the Web BETA at http://ca.messenger.yahoo.com/webmessengerpromo.php


In response to

pgsql-general by date

Next:From: William TemperleyDate: 2008-11-28 16:18:37
Subject: Re: Very large tables
Previous:From: Grzegorz JaƛkiewiczDate: 2008-11-28 16:03:52
Subject: Re: Very large tables

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