Re: No select privileges when not connecting from login postgres - Mailing list pgsql-general

From Joseph Brenner
Subject Re: No select privileges when not connecting from login postgres
Date
Msg-id CAFfgvXWG9nFyXmK6iqrbs2Sqjou2Sf+ZGFSaW49S+hWYwc93nw@mail.gmail.com
Whole thread Raw
In response to Re: No select privileges when not connecting from login postgres  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
List pgsql-general
> Any unusual errors in the logs?  Or maybe a "\o /somefile" in your
~doom/.psqlrc?

No, nothing much in the logs after "autovacuum launcher started", and
I don't have a .psqlrc file.

On Sat, Dec 3, 2016 at 6:56 AM, Julien Rouhaud
<julien.rouhaud@dalibo.com> wrote:
> On Wed, Nov 30, 2016 at 08:48:41PM -0800, Joseph Brenner wrote:
>> I'm trying to get a new build of 9.6.1 working on a machine
>> running Debian stable (jessie) and I'm seeing some odd
>> behavior where things work correctly if I run psql when
>> logged in as postgres, but if I run it as user 'doom' (my
>> usual login), I don't seem to have any select privileges.
>> Even this fails silenlty:
>>
>>   select 'world' as hello;
>>
>> But if run logged in as postgres, all is well:
>>
>>   sudo su - postgres
>>   /usr/local/pgsql/bin/psql --dbname=doom --username=doom
>>   doom=#   select 'world' as hello;
>>     select 'world' as hello;
>>     hello
>>    -------
>>     world
>>    (1 row)
>> [...]
>> I'm running out of ideas for things to check.  Any suggestions?
>>
>
> Any unusual errors in the logs?  Or maybe a "\o /somefile" in your
> ~doom/.psqlrc?
>
> --
> Julien Rouhaud
> http://dalibo.com - http://dalibo.org


pgsql-general by date:

Previous
From: Joseph Brenner
Date:
Subject: Re: No select privileges when not connecting from login postgres
Next
From: Joseph Brenner
Date:
Subject: Re: Select works only when connected from login postgres