| From: | ikedamsh <ikedamsh(at)oss(dot)nttdata(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | It is not documented that pg_promote can exit standby mode |
| Date: | 2020-04-17 04:11:31 |
| Message-ID: | de0068417a9f4046bac693cbcc00bdc9@oss.nttdata.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
The document(high-availability.sgml) says that there are only two ways
to exit standby mode.
26.2.2. Standby Server Operation
Standby mode is exited and the server switches to normal operation when
pg_ctl promote is run or a trigger file is found (promote_trigger_file).
But there is another way, by calling pg_promote function.
I think we need to document it, doesn't it?
I attached a patch. Please review and let me know your thoughts.
Regards,
Masahiro Ikeda
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-fix-doc-about-the-way-to-exit-standby-mode.patch | text/x-diff | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-04-17 04:21:02 | Re: ERROR: could not open file "pg_tblspc/ issue with replication setup. |
| Previous Message | Hamid Akhtar | 2020-04-17 04:07:23 | Re: Do we need to handle orphaned prepared transactions in the server? |