Re: Scalability Design Questions

Hi,

novnov wrote:
> OK, this has been very informative and I'd like to thank the three of you.
>
> Asynchronous replication to readonly slaves is something I will look into.
> I've never touched posgtres replication; and Scott mentioned that he was not
> familiar with PGCluster, so there must be some other replication system he's
> referencing, maybe Slony-I?

Not sure if you've found those, but just to make sure: there's the a
nice chapter in the official Postgres Documentation about High
Availability and Load Balancing [1]. Another starting point might be the
advocacy wiki at [2].

Regards

Markus

[1]: Postgres Documentation, Chapter 24. High Availability and Load
Balancing:
http://www.postgresql.org/docs/8.2/static/high-availability.html

[2]: Postgres Advocacy Wiki, Replication:
http://developer.postgresql.org/index.php/Replication%2C_Clustering%2C_and_Connection_Pooling