[pgpool-general: 5157] Re: install pgpool II as non-root user

[KALAGARA, KASTURI]

Thanks David.

The VIP question is for PGPOOL watch dog failover, not the database failover. Sorry my question was not clear.

From: David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco) [mailto:dsisk at cisco.com]
Sent: Thursday, December 08, 2016 10:02 AM
To: KALAGARA, KASTURI <KK1674 at att.com>; pgpool-general at pgpool.net
Subject: RE: install pgpool II as non-root user

For RHEL, use the rpm package, unless you simply cannot do it as root and don't have sudo privs.  I don't know if there's a tarball, but I'm sure someone will pipe in...

For automatic failover with PGPool, you don't need to move a VIP...PGPool (if configured correctly) will, once detecting the primary is down, 1) kill all app connections to the primary, 2) issue the pg_ctl promote on the standby (or whatever commands or script you've configured), then 3) reconnect all the app connections to the new primary...the app will see errors/disconnects while this is happening (takes a few seconds).

IMO, moving a VIP (or changing a DNS entry) is the worst possible way to failover a database...it almost guarantees you'll have a "split-brain" for some period of time.

HTH,

[banner2]



David Sisk
Engineer - Software
dsisk at cisco.com<mailto:dsisk at cisco.com>
Tel:

Cisco Systems, Inc.
7025-6 Kit Creek Road PO Box 14987
RESEARCH TRIANGLE PARK
27709-4987
United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you print.

This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.
Please click here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for Company Registration Information.


From: pgpool-general-bounces at pgpool.net<mailto:pgpool-general-bounces at pgpool.net> [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of KALAGARA, KASTURI
Sent: Wednesday, December 7, 2016 6:05 PM
To: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
Subject: [pgpool-general: 5155] install pgpool II as non-root user

Is it possible to install pg-pool II as non-root user? Is Tar ball install available for RHEL?

If setting up pg-pool 11 primary and standby for redundancy, how is the VIP failover controlled?

Thanks
Kasturi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161208/52c8a1f7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 48621 bytes
Desc: image003.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161208/52c8a1f7/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 832 bytes
Desc: image005.jpg
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161208/52c8a1f7/attachment-0001.jpg>