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

Re: Replication

From: Craig Servin <cservin(at)cromagnon(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication
Date: 2005-09-20 17:50:26
Message-ID: 200509201250.27031.cservin@cromagnon.com (view raw or flat)
Thread:
Lists: pgsql-admin
Are there any non-statement level solution?  Something that appends to the WAL 
on the slave server?



On Tuesday 20 September 2005 12:28 pm, Jim C. Nasby wrote:
> There's also pgcluster, but keep in mind that these are all
> statement-level replication solutions which have some rather big
> gotchas.
>
> On Mon, Sep 19, 2005 at 03:24:31PM -0500, Scott Marlowe wrote:
> > On Mon, 2005-09-19 at 02:02, the vespadict wrote:
> > > Hi ,
> > >
> > > I want high Availability but I don't need load balance. I need sync
> > > replication if is posible using two way.
> >
> > If you need sync, then pgpool may be a good choice, or client side
> > replication like C-JDBC or something like that.
> >
> > pgpool doesn't HAVE to do load balancing, it can do simple two way sync
> > replication if that's what you need.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> >        message can get through to the mailing list cleanly

In response to

Responses

pgsql-admin by date

Next:From: Chris HooverDate: 2005-09-20 17:55:43
Subject: Disk Access Question
Previous:From: Jim C. NasbyDate: 2005-09-20 17:28:02
Subject: Re: Replication

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