On Wed, Feb 27, 2019 at 12:59 PM Julie Nishimura
wrote:
> Hello Steve,
> Thanks a lot for your info yesterday, it was very useful. If I run this
> command on some of the servers and the results look like this, what would
> it tell you?
>
> select * from pg_extension ;
>extname| extowner
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
wha
Ouch. I'm sure others will have ideas to add but here are a few to start
with. I would start by cataloging the instances. I hope you at least have a
list of the servers - if not you may need to do network scans with nmap and
even then may not locate all of them.
On each instance I'd use some combi
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 slo
