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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
