How to make PAF use psql to login with password

2019-03-05 Thread
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 t

答复: [ClusterLabs] 答复: Postgres PAF setup

2018-04-25 Thread
clustering welcomed ; 范国腾 ; Andrew Edenburn ; pgsql-gene...@postgresql.org 主题: Re: [ClusterLabs] 答复: Postgres PAF setup On 04/25/2018 02:31 AM, 范国腾 wrote: > I have meet the similar issue when the postgres is not stopped normally. > > You could run pg_controldata to check if your

答复: [ClusterLabs] Postgres PAF setup

2018-04-24 Thread
I have meet the similar issue when the postgres is not stopped normally. You could run pg_controldata to check if your postgres status is shutdown/shutdown in recovery. I change the /usr/lib/ocf/resource.d/heartbeat/pgsqlms to avoid this problem: elsif ( $pgisready_rc == 2 ) { # The instance