From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | 范国腾 <fanguoteng(at)highgo(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "users(at)clusterlabs(dot)org" <users(at)clusterlabs(dot)org> |
Cc: | 祁华鹏 <qihuapeng(at)highgo(dot)com> |
Subject: | Re: How to make PAF use psql to login with password |
Date: | 2019-03-06 05:06:59 |
Message-ID: | bd333174-16dc-813b-757c-f5e90f42fbe5@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 3/5/19 5:57 PM, 范国腾 wrote:
> Hi,
>
> We use the PAF (https://dalibo.github.io/PAF/) to manage the postgresql.
>
>
> According to user's requirement, we could not use trust mode in the
> pg_hba.conf file. So when running psql, it will ask us to input the
> password and we have to input the password manually.
>
>
> So the pcs status show the following error:
>
> * pgsqld_stop_0 on node1-pri 'unknown error' (1): call=34,
> status=complete, exitreason='Unexpected state for instance "pgsqld"
> (returned 1)',
> last-rc-change='Wed Mar 6 09:09:46 2019', queued=0ms, exec=504ms
>
>
>
> The cause of the error is that the PAF
> (/usr/lib/ocf/resource.d/heartbeat/pgsqlms) will ask to input the
> password and we could not pass the password to psql command in the PAF
> script.
>
>
> exec $PGPSQL, '--set', 'ON_ERROR_STOP=1', '-qXAtf', $tmpfile,
> '-R', $RS, '-F', $FS, '--port', $pgport, '--host',
> $pghost,'--username','sysdba',
>
> Is there any way for us to pass the password to the psql command in the
> PAF script?
Use .pgpass?:
https://www.postgresql.org/docs/10/libpq-pgpass.html
>
> We have tried to add the "export PGPASSWORD=123456" in the /etc/profile
> and it does not work.
>
> thanks
>
>
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-03-06 05:09:11 | Re: Connection Drop from PostgreSQL Database Server |
Previous Message | Amit Langote | 2019-03-06 04:53:12 | Re: Update does not move row across foreign partitions in v11 |