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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2005-09-20 17:55:43 Disk Access Question
Previous Message Jim C. Nasby 2005-09-20 17:28:02 Re: Replication