Re: No select privileges when not connecting from login postgres

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