Hi,
Something happened while adding a node to one my pg apps and now I’m stuck with only a replica and the app/db does not work. I suspect this is because it cannot find a master and I’m hoping the data is still fine.
I have tried to get the data out manually but that seems easier said than done (though perhaps not impossible?) but I’m hoping I could change the role of the node and make a master.
Is there any way to manually make the replica a master node? I suspect there is but not sure where to start.
EDIT:
I was able to get the node back up in a working state by using the repmgr on the node to register it as a primary node and remove the non-existent node that was still registered in the cluster.