Re: No select privileges when not connecting from login postgres

> 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(dot)rouhaud(at)dalibo(dot)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