Re: Scalability Design Questions - Mailing list pgsql-general

From Markus Schiltknecht
Subject Re: Scalability Design Questions
Date
Msg-id 46EA7E72.6000303@bluegap.ch
Whole thread Raw
In response to Re: Scalability Design Questions  (novnov <novnovice@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Tablespaces on tertiary media
Next
From: Markus Schiltknecht
Date:
Subject: Re: oracle rank() over partition by queries