Marchetemsncom
Marchetemsncom

Reputation: 1

PostgreSQL v13 Streaming Replication Issue

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

Answers (0)

Related Questions