PostgreSql 9.3 High Availability Best Practices

From: Luis Marin <luismarinaray(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSql 9.3 High Availability Best Practices
Date: 2014-07-02 16:03:21
Message-ID: CAEp6HQVEz5px8Brn5FTXd0P8fKu6hSOe2DJb5_KBXVC07fETvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi list,

Just reviewing that there are many options to configure a High Availabity
environment using postgres 9.3,

http://www.postgresql.org/docs/9.3/interactive/different-replication-solutions.html
,

If we were to use Statement-Based Replication Middleware (PgPool) what
could I expect on terms of service confidence based on your experience,
taking into account that we are implementing our first postgresql HA
environment, what mistakes should I take into account so we will not fail
or be prepared for such situations and how we could manage.

Thanks for your ideas.

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2014-07-02 17:28:49 WAL archiving to 2 standby servers
Previous Message Michael Paquier 2014-06-30 11:34:37 Re: [ADMIN] [pgadmin-support] Best backup strategy for production systems