From: | Joseph Brenner <doomvox(at)gmail(dot)com> |
---|---|
To: | rob stone <floriparob(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: No select privileges when not connecting from login postgres |
Date: | 2016-12-03 22:55:35 |
Message-ID: | CAFfgvXVFBqbO0hF-NQNTBf0Jbv-bWzDbUrxWRMpGtq0qj_O1dQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Brenner | 2016-12-03 22:57:21 | Re: No select privileges when not connecting from login postgres |
Previous Message | Joseph Brenner | 2016-12-03 22:49:45 | Re: No select privileges when not connecting from login postgres |