I have an RDS Postgres instance whose role is Replica. I do not see the master in the same region and probably is in another region of the AWS account. How do I find the master for this replica?

Version 10.6

{`=> select pg_is_in_recovery();

(1 row)`}

I cannot query the recovery.conf due to lack of superuser privilege

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.