| From: | Praveen Kumar K S <praveenssit(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | [HELP] Query regarding failover |
| Date: | 2020-06-30 15:24:49 |
| Message-ID: | CANSiNp4REXa7QWEXvkT5ceESPC29iOVXU_Hjq52iL6GFzvc2uw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello Experts,
I'm using pgpool and configured postgres cluster with 1 master and 1slaves
with synchronous replication. Master is archiving WAL logs to a NAS share.
I'm using 9.6
I have read a few documentations and the failover and recovery are handled
in different ways. Few wrote shell scripts and passed it to pgpool and few
used tools like repmgr to handle automatic failover and recovery without
any manual intervention.
My requirement is to set up a process to handle failover and recovery
without manual intervention. I would like to know your suggestions if there
is any standard way of doing this or is it better to write custom scripts.
TIA.
--
*Regards,*
*K S Praveen Kumar*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marlene Villanueva | 2020-07-01 07:30:50 | Re: pg_basebackup compression |
| Previous Message | Mihalidesová Jana | 2020-06-30 12:01:45 | RE: Create extention CITEX failed |