Re: Broken postgres links need to find callers

On 10/31/18 11:48 AM, Rich Shepard wrote:
> 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

What does:

/usr/lib/postgresql/10.3/bin/pg_config --version

show?

What does:

ps ax | grep post

show?

>
>   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
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com