Thread: [GENERAL] Veritas cluster management
Hi, For any of you with those failover clusters, do you know if "pg_ctl reload" works (for compatible config file changes), or must we bounce the database using "hares -offline" then "hares -online"? Thanks -- World Peace Through Nuclear Pacification
On Wed, Aug 30, 2017 at 9:43 AM, Ron Johnson <ron.l.johnson@cox.net> wrote:
Hi,
For any of you with those failover clusters, do you know if "pg_ctl reload" works (for compatible config file changes), or must we bounce the database using "hares -offline" then "hares -online"?
pg_ctl reload does work in this case. HOWEVER, if you do something that could cause trouble to the cluster (i.e. a pg_hba.conf change that breaks connectivity), this could cause veritas to try and failover. It's recommended that you test your changes to avoid these scenarios.
Technically however, pg_ctl reload works just fine, just don't break anything :)
--Scott
Thanks
--
World Peace Through Nuclear Pacification
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 08/30/2017 08:48 AM, Scott Mead wrote:
On Wed, Aug 30, 2017 at 9:43 AM, Ron Johnson <ron.l.johnson@cox.net> wrote:Hi,
For any of you with those failover clusters, do you know if "pg_ctl reload" works (for compatible config file changes), or must we bounce the database using "hares -offline" then "hares -online"?pg_ctl reload does work in this case. HOWEVER, if you do something that could cause trouble to the cluster (i.e. a pg_hba.conf change that breaks connectivity), this could cause veritas to try and failover. It's recommended that you test your changes to avoid these scenarios.Technically however, pg_ctl reload works just fine, just don't break anything :)
That's great news. Many thanks.
-- World Peace Through Nuclear Pacification