Thread: MError after replication in postgresql

MError after replication in postgresql

From
Danish Hajwane
Date:

Hi Team,

We are getting error after doing replication on posrgresql 16.3 (OS is HP UX)
error is regarding Libpq library, we are unable to start sync getting error

FATAL: could not connect to the primary server : libpq is incorrectly linked to backend functions.
LOG: waiting for WAL to become available at 0/36000018.

Regards
Danish

Re: MError after replication in postgresql

From
Laurenz Albe
Date:
On Wed, 2024-09-25 at 10:57 +0530, Danish Hajwane wrote:
> We are getting error after doing replication on posrgresql 16.3 (OS is HP UX)
> error is regarding Libpq library, we are unable to start sync getting error
>
> FATAL: could not connect to the primary server : libpq is incorrectly linked to backend functions.
> LOG: waiting for WAL to become available at 0/36000018.

That means that there was a problem dynamically loading the
PostgreSQL client library into the server.

This depends a lot on how you built PostgreSQL, what operating system
you have and so on.  You didn't tell us anything about these details.

Yours,
Laurenz Albe



Re: MError after replication in postgresql

From
Muhammad Usman Khan
Date:
Hi,
There are many causes of this issue. One possible solution to handle this issue is to make sure that proper dynamic linking as follows:

export LD_LIBRARY_PATH=/path/to/pgsql/lib:$LD_LIBRARY_PATH

On Wed, 25 Sept 2024 at 10:35, Danish Hajwane <dane.hajs@gmail.com> wrote:

Hi Team,

We are getting error after doing replication on posrgresql 16.3 (OS is HP UX)
error is regarding Libpq library, we are unable to start sync getting error

FATAL: could not connect to the primary server : libpq is incorrectly linked to backend functions.
LOG: waiting for WAL to become available at 0/36000018.

Regards
Danish