[check_postgres] replicate_row not respecting --host2
Glyn Astill
glynastill at yahoo.co.uk
Fri Nov 7 13:18:38 UTC 2008
What happens if you swap out --host2 for the shorthand -H2? That's what I'm using, and it works here.
--- On Thu, 6/11/08, Jason Gordon <jgordon at millburncorp.com> wrote:
> From: Jason Gordon <jgordon at millburncorp.com>
> Subject: [check_postgres] replicate_row not respecting --host2
> To: check_postgres at bucardo.org
> Date: Thursday, 6 November, 2008, 7:12 PM
> 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.
> ######################################################################
> _______________________________________________
> Check_postgres mailing list
> Check_postgres at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/check_postgres
More information about the Check_postgres
mailing list