bucardo / check_postgres

Nagios check_postgres plugin for checking status of PostgreSQL databases
http://bucardo.org/wiki/Check_postgres
Other
561 stars 175 forks source link

check_postgres_connection v2.23.0 --output=simple issue #128

Open vameijenda opened 7 years ago

vameijenda commented 7 years ago

Running check_postgres_connection v2.23.0 produces different output to v2.22.0

v2.22.0

  1. Postgresql cluster running...

    check_postgres_connection --db=postgres --host=ieavu02 --output=simple

    Output = 1

  2. Postgresql cluster shutdown.....

    check_postgres_connection --db=postgres --host=ieavu02 --output=simple

    Output = 0

v2.23.0

  1. Postgresql cluster running...

    check_postgres_connection --db=postgres --host=ieavu02 --output=simple

    Output = 1

  2. Postgresql cluster shutdown.....

    check_postgres_connection --db=postgres --host=ieavu02 --output=simple

    could not connect to server: Connection refused Is the server running on host "ieavu02" (10.68.26.104) and accepting TCP/IP connections on port 5432?

Was expecting an Output = 0.

Thanks Victor

vameijenda commented 6 years ago

Hi,

The postgres linux user is invoking the check_postgres_connection script, v2.23.0 & v2.22.0

Output of command psql --db=postgres --host=ieavu02 is:

ieavu02 /home/postgres > psql --db=postgres --host=ieavu02

psql (9.6.6-Aviva Ireland build) Type "help" for help.

ieavu02: postgres@postgres=#

Thanks.

Regards

Victor

Victor Ameijenda Database Team Lead | Technical Infrastructure and Production Services | Global Infrastructure and Operations D: +353 (0) 1 89 88423 E: victor.ameijenda@aviva.commailto:victor.ameijenda@aviva.com

Aviva, Floor 3, One Park Place, Hatch Street, Dublin 2, Ireland.


From: maletin notifications@github.com Sent: 15 November 2017 12:05 To: bucardo/check_postgres Cc: Victor Ameijenda; Author Subject: Re: [bucardo/check_postgres] check_postgres_connection v2.23.0 --output=simple issue (#128)

Hi Victor, Who is invoking this script in which environment? What is the output of psql --db=postgres --host=ieavu02?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://clicktime.symantec.com/a/1/VpGvnjvO-buFbWHA1EVf5Zd4ohl5i5npegxHANUGRpw=?d=TBop1W_WOEtOen_Cc-b0hcKp9LTSXpN3axJUgRqQ6KCBVaqywLsD7loZsxK4RCXtN886PPT8oyjXI7xpg_LqEaN3AM5dmCY3KbVBQpgGm9tbTXw1zYggR35Xsxbwh1fWgNYqxt-fH-ehUz4UoITExOVUrkgD0oMqzxPr1rPaxqR5SlAbSF2kD83K1mPCt-MJ__bMOUOIfNKdquoLrDvie7RoOvNtjpk69bXHw5aDtnXCi5HbeV_iHKAtgMC9zWf-U_kmVewSnrWCNx6hc-jz4yvfPzKymeRQtAaFzEC6rI_hFCpa9IjbP2ok2UtVAFcSXvLZIaIC9x7adKP0ajoqi2lMOhtoG00RL0QKCU3J31E9bAP_jNe9EntleVNTSAXPeOefCrr3XNmjoc_G103zE2Jur4QlE-emOQwpHRAvQ1RJpoAjg2N2KACw8ql3oI2s0yzDTQdoyZusWw7wPLFDIEgcyJXrwQwqyw8VO-H9ifQU4VjGwg0YQLZ5F5sUE01Pmla85k5LsiV_9FDF&u=https%3A%2F%2Fgithub.com%2Fbucardo%2Fcheck_postgres%2Fissues%2F128%23issuecomment-344573125, or mute the threadhttps://clicktime.symantec.com/a/1/AI6q4RLeBb0khFDxwb17dPAE5E59aO02YIBaxWMVebY=?d=TBop1W_WOEtOen_Cc-b0hcKp9LTSXpN3axJUgRqQ6KCBVaqywLsD7loZsxK4RCXtN886PPT8oyjXI7xpg_LqEaN3AM5dmCY3KbVBQpgGm9tbTXw1zYggR35Xsxbwh1fWgNYqxt-fH-ehUz4UoITExOVUrkgD0oMqzxPr1rPaxqR5SlAbSF2kD83K1mPCt-MJ__bMOUOIfNKdquoLrDvie7RoOvNtjpk69bXHw5aDtnXCi5HbeV_iHKAtgMC9zWf-U_kmVewSnrWCNx6hc-jz4yvfPzKymeRQtAaFzEC6rI_hFCpa9IjbP2ok2UtVAFcSXvLZIaIC9x7adKP0ajoqi2lMOhtoG00RL0QKCU3J31E9bAP_jNe9EntleVNTSAXPeOefCrr3XNmjoc_G103zE2Jur4QlE-emOQwpHRAvQ1RJpoAjg2N2KACw8ql3oI2s0yzDTQdoyZusWw7wPLFDIEgcyJXrwQwqyw8VO-H9ifQU4VjGwg0YQLZ5F5sUE01Pmla85k5LsiV_9FDF&u=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAf9rR7i95yjQa2WF_lvW9De2z_kc3fRTks5s2tN9gaJpZM4QX16V.

Aviva Group Ireland plc. Registered in Ireland No 113223. Registered Office One Park Place, Hatch Street, Dublin 2.

Aviva Insurance Limited, trading as Aviva, is authorised by the Prudential Regulation Authority in the UK and is regulated by the Central Bank of Ireland for conduct of business rules.

Registered Branch Office in Ireland No 900175, Registered Branch Address One Park Place, Hatch Street, Dublin 2. Registered in Scotland No 2116. Registered Office Pitheavlis, Perth, PH2 0NH.

Aviva Direct Ireland Limited is regulated by the Central Bank Of Ireland. A private company limited by shares. Registered in Ireland No 374895. Registered Office One Park Place, Hatch Street, Dublin 2.

Aviva Life & Pensions UK Limited, trading as Aviva Life & Pensions Ireland, is authorised by the Prudential Regulation Authority in the UK and is regulated by the Central Bank of Ireland for conduct of business rules.

Aviva Life & Pensions UK Limited, trading as Aviva Life & Pensions Ireland, is also regulated in the UK: by the Prudential Regulation Authority for prudential rules and, to a limited extent, by the Financial Conduct Authority for applicable UK conduct rules. Registered Branch Office in Ireland (No 906464) at One Park Place, Hatch Street, Dublin 2. Registered in England (3253947) at Wellington Row, York, YO90 1WR

Aviva Life Services Ireland Limited is regulated by the Central Bank Of Ireland. A private company limited by shares. Registered in Ireland No 406616. Registered Office One Park Place, Hatch Street, Dublin 2.

www.aviva.ie

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer.