Search Postgresql Archives

Re: Setting up HA postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I made the following document 4 years back:
http://www.rummandba.com/2011/02/postgresql-failover-with-pgpool-ii.html

You may have a look if it makes any good to your work.

BTW, if you want to setup a share-nothing high scalable system with data-sharding, you can go for pl/proxy.

Thanks.

On Tue, Jul 21, 2015 at 10:55 AM, Aviel Buskila <aviel33@xxxxxxxxx> wrote:
Can you link me up to a good tutorial using pgpool-II?

2015-07-21 20:02 GMT+03:00 Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx>:

On 07/21/2015 08:34 AM, William Dunn wrote:
Hello Aviel,

On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila <aviel33@xxxxxxxxx
<mailto:aviel33@xxxxxxxxx>> wrote:

    How can I set a highly available postgresql in a share-nothing
    architecture?

I suggest you review the official documentation on high-availability
configurations linked below:
http://www.postgresql.org/docs/current/static/high-availability.html

The most common configuration is to use PostgreSQL's built in
master/standby streaming replication. However you will need to develop
any fail-over logic you need yourself or use a third party tool such as
EnterpriseDB's Failover Manager.

Or use already available open source tools such as Pgpool-II or Linux-HA.

Sincerely,
JD

--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux