проблемы с подключением к БД

[sgrinko]

postgres@mkgu-stage:~$ echo $PGDATA
/var/lib/postgresql/10
postgres@mkgu-stage:~$ echo $LD_LIBRARY_PATH
/opt/postgresql/10/lib
postgres@mkgu-stage:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 16.04.5 LTS
Release:        16.04
Codename:       xenial
postgres@mkgu-stage:~$ /opt/postgresql/10/bin/psql mkgu
psql.bin (10.4)
Type "help" for help.

Cannot read termcap database;
using dumb terminal settings.
mkgu=# select name, setting from pg_settings where name = 'unix_socket_directories';
          name           | setting
-------------------------+---------
 unix_socket_directories | /tmp
(1 row)

mkgu=# \q

root@mkgu-stage:/var/lib# ldd /opt/postgresql/10/bin/pg_probackup
        linux-vdso.so.1 =>  (0x00007ffe87ad5000)
        libpq.so.5 => /opt/postgresql/10/lib/libpq.so.5 (0x00007fa3e1dd9000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fa3e1bbc000)
        libz.so.1 => /opt/postgresql/10/lib/libz.so.1 (0x00007fa3e19a0000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fa3e15d6000)
        libssl.so.1.0.0 => /opt/postgresql/10/lib/libssl.so.1.0.0 (0x00007fa3e1366000)
        libcrypto.so.1.0.0 => /opt/postgresql/10/lib/libcrypto.so.1.0.0 (0x00007fa3e0f2f000)
        libgssapi_krb5.so.2 => /opt/postgresql/10/lib/libgssapi_krb5.so.2 (0x00007fa3e0cd5000)
        libldap_r-2.4.so.2 => /opt/postgresql/10/lib/libldap_r-2.4.so.2 (0x00007fa3e0a73000)
        /lib64/ld-linux-x86-64.so.2 (0x00007fa3e201f000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fa3e086f000)
        libkrb5.so.3 => /opt/postgresql/10/lib/libkrb5.so.3 (0x00007fa3e057a000)
        libk5crypto.so.3 => /opt/postgresql/10/lib/libk5crypto.so.3 (0x00007fa3e0334000)
        libcom_err.so.3 => /opt/postgresql/10/lib/libcom_err.so.3 (0x00007fa3e0131000)
        libkrb5support.so.0 => /opt/postgresql/10/lib/libkrb5support.so.0 (0x00007fa3dff24000)
        libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007fa3dfd09000)
        liblber-2.4.so.2 => /opt/postgresql/10/lib/liblber-2.4.so.2 (0x00007fa3dfaf9000)
        libsasl2.so.3 => /opt/postgresql/10/lib/libsasl2.so.3 (0x00007fa3df8d7000)
root@mkgu-stage:/var/lib#

postgres@mkgu-stage:~$ /opt/postgresql/10/bin/pg_probackup backup --backup-path=/mnt/pgbak -b full --stream --instance=10 -w -U postgres -h localhost -d postgres
INFO: Backup start, pg_probackup version: 2.0.17, backup ID: PGQIZM, backup mode: full, instance: 10, stream: true, remote: false
ERROR: could not open file "/var/lib/pgpro/std-10/data/global/pg_control" for reading: No such file or directory
postgres@mkgu-stage:~$

почему-то утилита хочет искать файл pg_control совсем не в том месте.
как обойти эту проблему?

[za-arthur]

Возможно вы указали данную папку при выполнении add-instance. Можете показать вывод команды show-config?

pg_probackup show-config --backup-path=/mnt/pgbak --instance=10

[sgrinko]

точно!

postgres@mkgu-stage:~$ pg_probackup show-config --backup-path=/mnt/pgbak --instance=10
#Backup instance info
PGDATA = /var/lib/pgpro/std-10/data
system-identifier = 6514524939530168466
#Connection parameters:
PGDATABASE = postgres
#Replica parameters:
#Logging parameters:
#Retention parameters:
retention-window = 7
#Compression parameters:
compress-algorithm = zlib
compress-level = 6
postgres@mkgu-stage:~$

заработало
я совсем забыл это проверить.
Спасибо

[za-arthur]

Отлично!