Re: Replication

From: Aldor <an(at)mediaroot(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication
Date: 2005-09-23 09:12:33
Message-ID: 4333C701.2080107@mediaroot.de
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?

For this kind of solution I'm also looking for a while - but in the
meantime you can also take a look at "slony" - it can do really many
things. Don't give up at the beginning, after you've understood how it
works you will like it ;-)

Craig Servin wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Cédric Buschini 2005-09-23 11:48:33 COPY TO / COPY FROM
Previous Message Hannes Dorbath 2005-09-23 07:51:02 Re: vacuum message