Re: Understanding PG9.0 streaming replication feature

Hi Ben,

On 2010/12/22 7:46, Ben Carbery wrote:
> FYI, not looking for a detailed how to here.. I have read the manual twice and just can't figure which sections are relevant. The manual seems to be trying to cover all uses simultaneously which is always going to get confusing :) For example do I need I need WAL archiving or not?

My blog entry would be a good entry point for you. :)

5 steps to implement a PostgreSQL replication system
http://pgsnaga.blogspot.com/2010/05/5-steps-to-implement-postgresql.html

It was written to be a guide for building a simple master-slave config.

Please take a look, including the comments.

Thanks,

On 2010/12/22 7:46, Ben Carbery wrote:
> FYI, not looking for a detailed how to here.. I have read the manual twice and just can't figure which sections are relevant. The manual seems to be trying to cover all uses simultaneously which is always going to get confusing :) For example do I need I need WAL archiving or not?
>
> On Tue, Dec 21, 2010 at 2:40 PM, Ben Carbery <ben(dot)carbery(at)gmail(dot)com <mailto:ben(dot)carbery(at)gmail(dot)com>> wrote:
>
> Hi,
>
> I am having some trouble trying to figure out how to configure this particular scenario..
>
> I have a pair of pg servers that I want to put in a Master/Standby configuration. Currently a script dumps the master db every hour, copies it to the standby, restores, and restarts the server. The aim is to replace the dumps/restores with streaming replication and ensure the standby is always up to date.
>
> In this case writes are infrequent, but reads are constant, and I only need high availability for reads. I would ideally like both master and standby to be available simultaneously to allow load-balancing.
> My confusion seems to be around the fact I don't need failover - my applications will detect a master down and immediately start using the standby, so there is no need to allow writes on the standby, they will just wait for the master to be available again - I am not sure what the minimum config needed for this scenario is..
>
> cheers,
>
> Ben
>
>
>
>

--
NAGAYASU Satoshi <satoshi(dot)nagayasu(at)gmail(dot)com>