Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Joseph Brenner
> Save yourself some trouble and use the PGDG repos... Yes, I was just trying one of those a little while ago. It exhibits the exact same behavior as my build from scratch. > In your psql commands you do not show connecting to port 5433 That's correct: my reading of the installation instruction

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Raymond O'Donnell
On 03/12/16 22:55, Joseph Brenner wrote: The version in the Debian stable repos right now is 9.4, and I saw an issue with it I wanted to check against the latest version, so I did a build of it from a tarball. You can get the latest version from the PostgreSQL apt repo: http://wiki.postgresq

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Adrian Klaver
On 12/03/2016 02:55 PM, Joseph Brenner wrote: The version in the Debian stable repos right now is 9.4, and I saw an issue with it I wanted to check against the latest version, so I did a build of it from a tarball. Save yourself some trouble and use the PGDG repos: https://www.postgresql.org/d

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Joseph Brenner
> 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 wrote: > On Wed, Nov 30, 2016 at 08:48:41PM -0800, Joseph Brenner

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Joseph Brenner
The version in the Debian stable repos right now is 9.4, and I saw an issue with it I wanted to check against the latest version, so I did a build of it from a tarball. (Admittedly, there's no particular reason I need to be running stable, and I was just wondering the other day why I wasn't using

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Joseph Brenner
Logged in as "doom", -V shows version 9.6.1 as I'd expect: /usr/local/pgsql/bin/psql -V psql (PostgreSQL) 9.6.1 To *literally* answer your question though, I have a different version installed in my $PATH: psql -V psql (PostgreSQL) 9.4.9 But yes, I've been invoking psql the same way as login 'd

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread rob stone
On Wed, 2016-11-30 at 20:48 -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 > us

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Adrian Klaver
On 11/30/2016 08:48 PM, 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

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Julien Rouhaud
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' (m

[GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Joseph Brenner
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 fa