Re: replication topography

On 2/26/19 2:40 PM, Julie Nishimura wrote:
> 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?

In addition to what Steve posted:

1) Do a search on the machines for the file PG_VERSION. That will locate 
the the PGDATA directory for each instance.

2) Are you dealing with the same OS across the servers?
Can you use the package manager to ferret out the Postgres servers?


> 
> Some of them stand alone instances, but some are mirrored. And of 
> course, developers want to know answers NOW:)

Well either:

1) They don't how things where setup in the past and still managed to 
get development done, so the need to know NOW is just panicking.

2) They do know some or all of the layout and can contribute to the 
solution.

> 
> 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


-- 
Adrian Klaver
adrian.klaver@aklaver.com