Check PostgreSQL status using MS-DOS bat file?

From: "Loughrey, Hugh" <Hugh(dot)Loughrey(at)hoopleltd(dot)co(dot)uk>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Check PostgreSQL status using MS-DOS bat file?
Date: 2012-08-15 09:52:17
Message-ID: FCDCCEB29F5F9F479B441D4A295F33353BF60A8F@HC-EXMBX03.herefordshire.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I want to write a MS-DOS command to check that the PostgreSQL database is up and running and able to accept data being pushed to it. From a bit of reading I've identified the pg_ctl status command, but can this be incorporated into a *.bat file and can the resulting status be recorded in a *.txt file? If so does anyone have a command which would enable this?

Regards

Hugh Loughrey
GIS Application Analyst
Hoople Ltd | Thorn Office Centre | Hereford HR2 6JT
Tel: 01432 383566 | Email: hugh(dot)loughrey(at)hoopleltd(dot)co(dot)uk<mailto:hugh(dot)loughrey(at)hoopleltd(dot)co(dot)uk>
General email: enquiries(at)hoopleltd(dot)co(dot)uk<mailto:enquiries(at)hoopleltd(dot)co(dot)uk>
Website: www.hoopleltd.co.uk<http://www.hoopleltd.co.uk>

"Any opinion expressed in this e-mail or any attached files are those of the individual and not necessarily those of Hoople Ltd. You should be aware that Hoople Ltd. monitors its email service. This e-mail and any attached files are confidential and intended solely for the use of the addressee. This communication may contain material protected by law from being passed on. If you are not the intended recipient and have received this e-mail in error, you are advised that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. If you have received this e-mail in error please contact the sender immediately and destroy all copies of it.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neanderthelle Jones 2012-08-15 10:24:17 More probs with BLOBs
Previous Message Carl von Clausewitz 2012-08-15 07:57:25 corrupted statistics file "pg_stat_tmp/pgstat.stat"