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

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 (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?


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

pgsql-admin by date

Next:From: C├ędric BuschiniDate: 2005-09-23 11:48:33
Subject: COPY TO / COPY FROM
Previous:From: Hannes DorbathDate: 2005-09-23 07:51:02
Subject: Re: vacuum message

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