inetplus
inetplus
Hi, thanks for quick response and please find below the answers for your queries - [ x] repmgr is installed from package Installed Packages Name : repmgr11 Arch : x86_64...
Please let me know when you need any other information or support from my side thanks
here is the result: postgres=# SELECT * FROM pg_file_settings WHERE name = 'data_directory'; -[ RECORD 1 ]-------------------------------------- sourcefile | /var/lib/pgsql/11/data/postgresql.conf sourceline | 41 seqno | 1 name | data_directory setting...
/usr/pgsql-11/bin/pg_ctl -D /var/lib/pgsql/11/data/ status pg_ctl: no server running /usr/pgsql-11/bin/pg_ctl -D /mnt/mydbDirectory/pgsql/11/data/ status pg_ctl: server is running (PID: 14425)
I see that i copied the latest test log **[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"** you see the parameter **-D**...
when i execute the command > /usr/pgsql-11/bin/pg_ctl -w -D '/var/lib/pgsql/11/data' promote /usr/pgsql-11/bin/pg_ctl -w -D '/var/lib/pgsql/11/data' promote pg_ctl: PID file "/var/lib/pgsql/11/data/postmaster.pid" does not exist Is server running?
just one more information. the file **postmaster.pid** exists in the data folder **/mnt/mydbDirectory/pgsql/11/data** i hope it helps a little bit more.
do u have any feedback for me how to continue? thanks
Hi i have read all information from this link that you provide me: **https://www.postgresql.org/docs/current/app-pg-ctl.html** it is written that the parameter -D points to data directory. PGDATA in the environment variable...
I am not sure whether i understood it properly because of that i would like to summary this issue from my point of view. PostgresSQL 11 is installed in CENTOD...