Re: Postgres replication: dump/restore, PITR, Slony,...?

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Shaul Dar <shauldar(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres replication: dump/restore, PITR, Slony,...?
Date: 2009-06-11 14:33:04
Message-ID: 877hzizvq7.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Shaul Dar <shauldar(at)gmail(dot)com> writes:
> 1. A staging server, which receives new data and updates the DB
> 2. Two web servers that have copies of the DB (essentially read-only)
> and answer user queries (with load balancer)

[...]

> Suggestions?

I'd consider WAL Shipping for the staging server and some trigger based
asynchronous replication for feeding the web servers.

More specifically, I'd have a try at Skytools, using walmgr.py for WAL
Shipping and Londiste for replication.
http://wiki.postgresql.org/wiki/Skytools
http://wiki.postgresql.org/wiki/Londiste_Tutorial

Regards,
--
dim

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-06-11 15:07:12 Re: GiST index performance
Previous Message Tom Lane 2009-06-11 13:27:36 Re: GiST index performance