| From: | Julie Nishimura <juliezain(at)hotmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | replication topography |
| Date: | 2019-02-26 22:40:52 |
| Message-ID: | BYAPR08MB5014541A2214E5F50872DE30AC7B0@BYAPR08MB5014.namprd08.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2019-02-26 23:38:06 | Re: replication topography |
| Previous Message | Michael Paquier | 2019-02-26 22:35:28 | Re: Channel binding not supported using scram-sha-256 passwords |