Ian Barwick
Ian Barwick
Hi Was either the local or upstream PostgreSQL node inactive/unreachable for a longer period? There is a memory leak in 4.2 which occurs when one of the monitored nodes is...
> Not really, the nodes were behind replicating but part of the cluster according to `cluster show` everything was fine. Hmm, could you provide the `repmgrd` logs anyway? Preferably for...
- which node are you running `repmgr cluster show` on? - is the former primary still running? You will see this output if a standby was promoted, but (for whatever...
> Hi, I'll be looking for secure authentication for Postgres where i should not use .pgpass or trust authentication method. > (...) > Requirements: > > 1. is there any...
Thanks for the suggestion - however the whole point of `repmgrd` is to have a durable monitoring instance which can run even when the monitored PostgreSQL instance is down; a...
First we need to be able to reproduce the issue. > pg_ctl: PID file "/var/lib/pgsql/11/data/postmaster.pid" does not exist > > The reason of this error message - as far as...
Thanks. Could you also attach the output of: SELECT * FROM pg_file_settings WHERE name = 'data_directory'\gx
Thanks. Next one: please provide the output of the following commands: pg_ctl -D /var/lib/pgsql/11/data/ status pg_ctl -D /mnt/mydbDirectory/pgsql/11/data
This is odd - you have two `-D` parameters in the `pg_ctl` command: `[2019-08-21 16:41:40] [DETAIL] promoting server "fra2intdpamdb002" (ID: 2) using "/usr/pgsql-11/bin/pg_ctl -D /mnt/mydbDirectory/pgsql/11/data -w -D '/var/lib/pgsql/11/data' promote"` Please...
I haven't been able to reproduce this issue yet. The only thing I can think of right now is that as you are using RHEL7 (or a variant thereof), and...