| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | "Loughrey, Hugh" <Hugh(dot)Loughrey(at)hoopleltd(dot)co(dot)uk> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>, Dave Page <dpage(at)pgadmin(dot)org> |
| Subject: | Re: Check PostgreSQL status using MS-DOS bat file? |
| Date: | 2012-08-15 15:04:27 |
| Message-ID: | 20120815150427.GC25485@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 15, 2012 at 09:52:17AM +0000, Loughrey, Hugh wrote:
> 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?
As I remember it is pretty tricky to call pg_ctl from a Windows batch
file. I know the Windows installers do it somehow --- you might want to
downlaod it and see if you can find the shell script they use. Dave
Page might know more --- CC'ing him.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2012-08-15 15:29:43 | Re: Check PostgreSQL status using MS-DOS bat file? |
| Previous Message | Bruce Momjian | 2012-08-15 14:28:55 | Re: PG Installer - Licensing Issues |