> 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@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
