[check_postgres] replicate_row not respecting --host2

Jason Gordon jgordon at millburncorp.com
Thu Nov 6 19:12:21 UTC 2008


I am trying to use the replicate_row action and it seems to be  
ignoring the host2 parameter and trying to connect to localhost.

./check_postgres.pl --action=replicate_row --host=dbmaster1 -- 
dbname=tmc --host2=dbstage1 --dbname2=tmc --warning=10 -- 
repinfo=application_state,application,check_postgres,value,foo,bar
ERROR: could not connect to server: No such file or directory
         Is the server running locally and accepting
         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


When I use -v -v -v, I see at the bottom:

Starting run_command with "SELECT "value" FROM "application_state"  
WHERE "application" = 'check_postgres'"
$POSTGRES1 = [
                "-q",
                "-U",
                "postgres",
                "-d",
                "tmc",
                "-t",
                "-p",
                5432,
                "-o",
                "/tmp/yCTD9UCr8N/check_postgres_psql.2AutXTW.tmp",
                "-c",
                "SELECT \"value\" FROM \"application_state\" WHERE  
\"application\" = 'check_postgres'"
              ];
System call failed with a 512



Other similar output always seems to have the -h in the param list.

Suggestions?  I am using 2.4.2.

Thanks,
Jason

######################################################################
This email is confidential, does not constitute investment advice, is
only for the use of the intended recipient and should not be
redistributed, except with the sender's consent. If you received this
email in error, please notify us immediately by telephone; receipt by
anyone other than the intended recipient is not a waiver of any
work-product or attorney-client privilege. All email to and from
Millburn Ridgefield Corporation and its affiliates is monitored,
stored and made available to regulators if requested.
######################################################################


More information about the Check_postgres mailing list