Hello everybody,
I've inherited big complicated postgresql kingdon with multiple servers in it, some of them are replicated, some of them are not, and there is Bunch of them.
What would you be your suggestion, how should I start my investigation what is master, what is replicas, is there any slony/streaming replication. etc?
Some of them stand alone instances, but some are mirrored. And of course, developers want to know answers NOW:)
The versions are mainly 8.3 and 9.4. So, pg_is_in_recovery shows either function doe not exist (on 8.3) or "f" for 9.4 (which can mean it is master, right)?
Any advises are greatly appreciated.
Thank you,
Julie