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:38:15
Message-ID: 6968c432-c9c7-6241-55da-8b078e6e56ed@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.
>

Another thought do you have the PGDATA environment variable set for your
user1?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Leroy - Inikup 2018-04-11 23:43:08 Re: Commands linked to pg_wrapper not working with non-root users
Previous Message Adrian Klaver 2018-04-11 23:32:39 Re: Commands linked to pg_wrapper not working with non-root users