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

On 04/11/2018 04:20 PM, Jonathan Leroy - Inikup wrote:
> 2018-04-12 0:26 GMT+02:00 Tim Cross <theophilusx@gmail.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.klaver@aklaver.com