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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings