t-matsuo/resource-agents — Issue #9: pgsql_validate_all fail on Master and Postgresl not initialized
Author: lionelg3
Created: 2012-02-03 14:36:20+00:00
State: open

Hi,

I'm try to make if work on Debian6 using Posrgresql 9.1.2 (version from backports) and Corosync 1.1.6 .

### On line 1799; pgsql_validate_all always fail with the error :
Feb 03 15:12:30 bdd2 lrmd: [27051]: info: RA output: (HA_POSTGRESQL\:1:start:stderr) [: 1799:
Feb 03 15:12:30 bdd2 lrmd: [27051]: info: RA output: (HA_POSTGRESQL\:1:start:stderr) 9.1: unexpected operator
Feb 03 15:12:30 bdd2 lrmd: [27051]: info: RA output: (HA_POSTGRESQL\:1:start:stderr)

### So, I comment line 1799;

Now Postgresql start but all servers are in "HS:alone" status, the master is not found.
I think the script run to fast and does not wait Postresql:Master be initialized (line 1797)

### On the master server I always see in log (with pghost="127.0.0.1")
Feb 03 15:17:31 bdd2 lrmd: [27051]: info: RA output: (HA_POSTGRESQL:1:start:stderr) psql: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?

### Or (without pghost) :
Feb 03 15:20:58 bdd2 lrmd: [27051]: info: RA output: (HA_POSTGRESQL:1:start:stderr) psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?