Re: Commands linked to pg_wrapper not working with non-root users

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Jonathan Leroy - Inikup <jonathan(at)inikup(dot)com>, Tim Cross <theophilusx(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Commands linked to pg_wrapper not working with non-root users
Date: 2018-04-11 23:32:39
Message-ID: 55bc694a-ba69-7377-e39d-867a8f4c507c@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/11/2018 04:20 PM, Jonathan Leroy - Inikup wrote:
> 2018-04-12 0:26 GMT+02:00 Tim Cross <theophilusx(at)gmail(dot)com>:
>> Check your settings in /etc/postgresql-common/user_clusters. The wrapper
>> script uses that file to determine what databases to connect to or what
>> is the user default database cluster. It can also be overridden with a
>> local ~/.postgresqlrc, so check there are no old settings there as well.
>
> Thank you Tim.
>
> The file /etc/postgresql-common/user_clusters is empty on all servers
> (it only contains comments). None of my users have a ~/.postgresqlrc
> file.
>

What are the permissions on /usr/bin/psql?

On my Ubuntu 16.04 instance I have:

lrwxrwxrwx 1 root root 37 Feb 8 04:55 /usr/bin/psql ->
../share/postgresql-common/pg_wrapper*

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-04-11 23:38:15 Re: Commands linked to pg_wrapper not working with non-root users
Previous Message Adrian Klaver 2018-04-11 23:27:01 Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2