Getting error on repmgr5.0 with PostgreSQL12 ( while configuring and cloning standby server ) ( undefined symbol: PQconninfo )

[khanna43]

-bash-4.2$ /usr/pgsql-12/bin/repmgr -h sbx1pri -U repmgr -d repmgr -f /etc/repmgr/12/repmgr.conf standby clone --dry-run
NOTICE: destination directory "/home/postgres/data" provided
INFO: connecting to source node
DETAIL: connection string is: host=sbx1pri user=repmgr dbname=repmgr
DETAIL: current installation size is 2852 MB
INFO: "repmgr" extension is installed in database "repmgr"
INFO: parameter "max_wal_senders" set to 5
NOTICE: checking for available walsenders on the source node (2 required)
INFO: sufficient walsenders available on the source node
DETAIL: 2 required, 5 available
NOTICE: checking replication connections can be made to the source server (2 required)
/usr/pgsql-12/bin/repmgr: symbol lookup error: /usr/pgsql-12/bin/repmgr: undefined symbol: PQconninfo
-bash-4.2$

Configuration file details

node_id=2
node_name='sbx2pri'
conninfo='host=sbx2pri user=repmgr dbname=repmgr connect_timeout=2'

data_directory='/home/postgres/data'

[eulerto]

It seems you are using an old libpq. PQconninfo was introduced in Postgres 9.3. Check which libpq, repmgr is using:

ldd /usr/pgsql-12/bin/repmgr | grep libpq
	libpq.so.5 => /usr/pgsql-12/lib/libpq.so.5 (0x00007f4ad5f30000)

If it is not from a recent postgres version, install a newer postgresqlXX-libs package. Since you are using repmgr12, I recommend that you install postgresql12-libs. You can check the installed postgresqlXX-libs packages using:

yum list installed | grep 'postgresql..-libs'

If postgresql12-libs is already installed, you probably have to fix the path that your system searches for shared objects (LD_LIBRARY_PATH).

[khanna43]

Thanks you for the prompt response. After installing the Postgres12 libs and setting up the LD Path, the issue was resolved. yum install postgresql12-libs export LD_LIBRARY_PATH=/usr/pgsql-12/lib/libpq.so.5 Thanks and Regards khanna.43

…

On Sun, Nov 22, 2020 at 8:54 PM Euler Taveira ***@***.***> wrote: It seems you are using an *old* libpq. PQconninfo was introduced in Postgres 9.3. Check which libpq, repmgr is using: ldd /usr/pgsql-12/bin/repmgr | grep libpq libpq.so.5 => /usr/pgsql-12/lib/libpq.so.5 (0x00007f4ad5f30000) If it is not from a recent postgres version, install a newer postgresqlXX-libs package. Since you are using repmgr12, I recommend that you install postgresql12-libs. You can check the installed postgresqlXX-libs packages using: yum list installed | grep 'postgresql..-libs' If postgresql12-libs is already installed, you probably have to fix the path that your system searches for shared objects (LD_LIBRARY_PATH). — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#681 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHZ5SVLNFY5RPXQTJ5XWQQTSREUKJANCNFSM4T4KQGSA> .

[ibarwick]

Thanks for the feedback, closing this.