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