pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

No mention of standby.signal in pg_ugprade docs
2+ messages / 2 participants
[nested] [flat]

* No mention of standby.signal in pg_ugprade docs
@ 2021-07-15 18:39  Dan Stoner <dstoner@iris.washington.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Dan Stoner @ 2021-07-15 18:39 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org

Hi,

I noticed that  standby.signal is not mentioned anywhere in the pg_upgrade document.

https://www.postgresql.org/docs/13/pgupgrade.html

I had trouble the first time I tried to start my secondary because it didn't connect to the primary / start streaming until I touched the signal 
file.  The signal file is obliterated during the rsync but there is no mention of putting it back or preserving it.


Here is what the docs currently read:

10. Upgrade streaming replication and log-shipping standby servers
...
e. Save configuration files

Save any configuration files from the old standbys' configuration directories you need to keep, e.g., postgresql.conf (and any files included by it), postgresql.auto.conf, pg_hba.conf, because these will be overwritten or removed in the next step.



Maybe a mention of standby.signal would make sense under:

g. Configure streaming replication and log-shipping standby servers



Thanks for considering this change.


Dan Stoner






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: No mention of standby.signal in pg_ugprade docs
@ 2021-07-16 05:19  Laurenz Albe <laurenz.albe@cybertec.at>
  parent: Dan Stoner <dstoner@iris.washington.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Laurenz Albe @ 2021-07-16 05:19 UTC (permalink / raw)
  To: Dan Stoner <dstoner@iris.washington.edu>; pgsql-docs@lists.postgresql.org

On Thu, 2021-07-15 at 14:39 -0400, Dan Stoner wrote:
> I noticed that  standby.signal is not mentioned anywhere in the pg_upgrade document.
> 
> https://www.postgresql.org/docs/13/pgupgrade.html
> 
> I had trouble the first time I tried to start my secondary because it didn't connect to the primary / start streaming until I touched the signal 
> file.  The signal file is obliterated during the rsync but there is no mention of putting it back or preserving it.

I think you are right.

I will incorporate that in my patch to improve the documentation:
https://www.postgr.es/m/22f129004bb66cd91e1dfd3345a9787f5039f3ae.camel%40cybertec.at

Yours,
Laurenz Albe






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2021-07-16 05:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-07-15 18:39 No mention of standby.signal in pg_ugprade docs Dan Stoner <dstoner@iris.washington.edu>
2021-07-16 05:19 ` Laurenz Albe <laurenz.albe@cybertec.at>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox