[check_postgres] Host names not displayed when using dbservice

Guillaume Lelarge guillaume at lelarge.info
Mon Oct 10 08:44:13 UTC 2011


On Wed, 2011-10-05 at 13:23 -0500, Mike Blackwell wrote:
> It appears the host names are not being filled in when using the dbservice
> option.
> The databases are on different hosts.
> ---
> $check_postgres.pl --timeout=60 \
>         --action=same_schema \
>         --dbservice=foo,bar \
>         --exclude='^pg_catalog' --exclude='^information_schema' \
> 
> --filter=nouser,noindex,noconstraint,nofunction,nosequence,noposition \
>         --verbose
> 
> POSTGRES_SAME_SCHEMA CRITICAL: service=foo Databases were different. Items
> not matched: 105 | time=2.60s
> DB 1: host=<none>
> DB 1: PG version: 8.3.6
> DB 1: Total objects: 1817
> DB 2: host=<none>
> DB 2: PG version: 8.3.6
> DB 2: Total objects: 1767
> <snip>
> 

Can you try on the latest git version? Greg did some work on the service
issues. And it seems to work for us now.


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com



More information about the Check_postgres mailing list