The following bug has been logged on the website:
Bug reference: 9118
Logged by: Joel Hedden
Email address: jhedden@apple.com
PostgreSQL version: 9.3.2
Operating system: Mac OS X 10.9.1
Description:
I connect a pg_receivexlog instance and have "hot_standby" archiving
enabled, with "archive_command" defined correctly. When the WAL Sender
process receives a SIGUSR2 from the postmaster (or me), it fails to shut
down and pg_receivexlog remains connected. Upon inspection, it looks like
the test for "sentPtr == MyWalSnd->flush" is always false at
walsender.c:1058 (sentPtr is still non-zero) where the wal sender should be
shutting down. Replication and archiving seem to be working otherwise.
Killing pg_receivexlog allows for the WAL Sender to terminate.
This didn't affect 9.2.4 for me.
I've tested the EnterpriseDB 9.3.2 release as well as the HEAD branch for
9.3.
To reproduce:
1. Download the EnterpriseDB 9.3.2 distribution for Mac OS X and install
onto 10.9.1.
2. Use initdb to create a fresh cluster.
3. Update postgresql.conf:
- max_wal_senders = 2
- wal_level = hot_standby
- archive_mode = on
- archive_command = '/usr/bin/true'
4. Update pg_hba.conf to allow local replication connections.
5. Start postgres.
6. Connect pg_receivexlog via local socket file.
7. kill -TERM the postmaster.
The WAL sender, logger, and postmaster continue to run indefinitely and
pg_receivexlog is not disconnected. WAL sender receives the SIGUSR2 from
postmaster but does not disconnect pg_receivexlog and shut down as expected.