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

[David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco)]

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] On Behalf Of KALAGARA, KASTURI
Sent: Wednesday, December 7, 2016 6:05 PM
To: 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/8dd43b31/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 121724 bytes
Desc: image001.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161208/8dd43b31/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 1469 bytes
Desc: image002.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161208/8dd43b31/attachment-0003.png>