Re: Broken postgres links need to find callers

On Wed, 31 Oct 2018, Andrew Gierth wrote:

> Is there a pg_config binary in /usr/lib/postgresql/10.3/bin/ and if so,
> what is the output of /usr/lib/postgresql/10.3/bin/pg_config --sharedir

Andrew,

   Yes, pg_config is present but pointing to the wrong directory:
# /usr/lib/postgresql/10.3/bin/pg_config --sharedir
/usr/share/postgresql-10.2

   However, the file dates are that of the upgrade from 10.2 to 10.3:

-rwxr-xr-x 1 root root 7096448 Mar  1  2018 postgres*
lrwxrwxrwx 1 root root       8 Mar  1  2018 postmaster -> postgres*
-rwxr-xr-x 1 root root  514732 Mar  1  2018 psql*

and the postgres version is 10.3:

> Also what is the output of  /usr/lib/postgresql/10.3/bin/postgres -V

# /usr/lib/postgresql/10.3/bin/postgres -V
postgres (PostgreSQL) 10.3

> The most plausible explanation I can see for what you're seeing there is
> that what you have as /usr/lib/postgresql/10.3/bin/postgres is not
> actually the 10.3 binary but rather the 10.2 one. There should be no
> symlinks involved there - the path that is reported in the error message
> is the one that the postgres binary actually did try to open.

   Can pg_config be corrected independent of anything else. That seems to be
where the blockage is found.

Thanks,

Rich