Reputation: 1
Using PostgreSQL v13
streaming replication setup between a primary, and secondary (Hot Standby) server. After maintenance reboots of each server were complete, the secondary (a read-replica) is stuck in recovery mode with a status=streaming
. This event has caused a failure in the replication of data. Is there a graceful way to recover? Any help is greatly appreciated.
I have reviewed configuration setup, and files ( postgresql.conf & pg_hba.conf
) are correct- Replication was working prior to reboots.
Logs on the Hot Standby (Secondary) indicate-
Standby.signal file is present in the Standby servers data directory- Can I just remove the file and restart PostgreSQL
service? Or, do I have to promote the Hot Standby to Primary (What do I need to do with the current primary?) to let it recover fully?
Again, any help would be appreciated. Thank you in advance, for any time and consideration regarding this issue.
Upvotes: 0
Views: 65