Re: nohup psql does not read .pgpass

From: Hans Ginzel <hans(at)matfyz(dot)cz>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: nohup psql does not read .pgpass
Date: 2015-06-29 10:11:16
Message-ID: 16c53665f224a2cac113528c59888255@artax.karlin.mff.cuni.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am sorry. The difference in the behaviour of psql command is because
psql alias versus psql binary.
The time command is bash internal which respects aliases.

HG

Dne 29.06.2015 11:11, Hans Ginzel napsal:

> Dne 29.06.2015 10:47, Hans Ginzel napsal:
>
>> Hello! Can you, please, help me determinate why psql does not read
>> the
>> ~/.pgpass file when used with nohup? echo 'select 1+1' >one.sql psql
>> -a
>> --file=one.sql db # works time psql -a --file=one.sql db # works
>> nohup
>> psql -a --file=one.sql db # asks for password
>
> More precisely, this does not ask for password because of peer
> authentication method,
> but the login name to user name rewrite from .pgpass is not used.
>
>> Environment variables are same env >e nohup env >ne diff e ne 26c26
>> <
>> _=/bin/env ---
>>
>>> _=/usr/bin/nohup
>> psql --version psql (PostgreSQL) 9.4.0 nohup --version nohup (GNU
>> coreutils) 8.4 cat /etc/system-release CentOS release 6.6 (Final) I
>> have read and searched
>> http://www.postgresql.org/docs/9.4/static/app-psql.html [1]
>> http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html [2] but
>> did
>> not find any indices. Regards Hans Ginzel

Links:
------
[1] http://www.postgresql.org/docs/9.4/static/app-psql.html
[2] http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stefano Mioli 2015-06-30 17:54:14 Locking issues under transaction
Previous Message Hans Ginzel 2015-06-29 09:11:02 Re: nohup psql does not read .pgpass