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 testing or unstable). The build steps I used are relatively conventional (following the directions in the INSTALL file): this is how I ended up with an installation in /usr/local. The only thing unusual about the steps that I followed was I built with port 5433 (rather than 5432) as the default, to make it easier to run it in parallel with the system version, and I'm trying to use the "with-perl" build option to link to a fresh build of perl: sudo su export LD_LIBRARY_PATH='/home/doom/End/Sys/Perl5/perl-5.24.0' ldconfig ./configure --with-pgport=5433 --with-perl --with-openssl make make install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data mkdir /var/lib/postgresql-9.6.1/ chown postgres /var/lib/postgresql-9.6.1/ su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data > /var/lib/postgresql-9.6.1/logfile 2>&1 & On Sat, Dec 3, 2016 at 7:23 AM, rob stone <floriparob@xxxxxxxxx> wrote: > > 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 >> 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 run Debian testing (stretch/sid). > > For years now, the Postgres binaries are stored in:- > > /usr/lib/postgresql/<major version>/bin > > and are root:root owned. > > E.g.:- > > /usr/lib/postgresql/9.6/bin/psql appears as:- > > -rwxr-xr-x 1 root root 580864 Nov 2 21:04 psql > > So, it is executable by anybody, which is not an issue with me. > > The reason behind this path convention is to enable you to run > different major versions of Postgres on the same computer. > > I don't know how you installed Postgres and all I can suggest for > starters is to physically remove it and re-install from the Debian > packages. > > HTH, > Rob -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
