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