Re: Postgresql replication - Mailing list pgsql-general

From Chris Travers
Subject Re: Postgresql replication
Date
Msg-id 430D6558.8040605@travelamericas.com
Whole thread Raw
In response to Re: Postgresql replication  (Carlos Henrique Reimer <carlosreimer@yahoo.com.br>)
Responses Re: Postgresql replication  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-general
Carlos Henrique Reimer wrote:

> I read some documents about replication and realized that if you plan
> on using asynchronous replication, your application should be designed
> from the outset with that in mind because asynchronous replication is
> not something that can be easily “added on” after the fact.
> Am I right?

Depending on your needs, you may find pgpool and Slony to be a workable
combination. This is better when you have a lot of reads and only
occasional writes. This way writes get redirected back to the master,
and read-only transactions get run on the slaves.

Best Wishes,
Chris Travers
Metatron Technology Consulting

pgsql-general by date:

Previous
From: Bill Moseley
Date:
Subject: Help with a subselect inside a view
Next
From: William Yu
Date:
Subject: Re: Postgresql replication