Re: Check PostgreSQL status using MS-DOS bat file?

Hi ,

Dave's instructions are helpful for finding the status of the server..
However, I do have the below the script which is nothing but PgPing in
windows ... I hope it helps you in the implementation ..

@ECHO OFF

set PSQL="C:\Program Files\PostgreSQL\9.1\bin"

set DBNAME="template1"

set USER="postgres"

set PORT="5432"

set RES="Not Pinging"

%PSQL%\psql -Atq -c "SELECT 'ping'" -p %PORT% -U %USER% %DBNAME% > _Res.txt

set /p RES=<_Res.txt

echo %RES%

IF %RES% EQU ping (echo "No need to raise any exception ") else (echo
"PostgreSQL seems not pinging.. Need to raise an exception")

Best Regards,
Dinesh
manojadinesh.blogspot.com

On Fri, Aug 17, 2012 at 4:32 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> [Please keep the mailing list CC'd]
>
> On Fri, Aug 17, 2012 at 11:52 AM, Loughrey, Hugh
> <Hugh(dot)Loughrey(at)hoopleltd(dot)co(dot)uk> wrote:
> > Hi Dave,
> >
> > Thanks for the message below. The script you forwarded looks to be for
> an instance in which the DB is running of a windows box, apologies I should
> have mentioned, we currently run PostgreSQL on a Linux box. Does this mean
> calling pg_ctl is not an option? Or do we need to install additional
> drivers?
>
> pg_ctl only checks the status of an instance running on the local
> machine. To check on a remote linux box from windows using pg_ctl,
> you'd have to run pg_ctl on the linux box, probably over SSH (look for
> Putty for an SSH client for Windows).
>
> An easier option might be to run a psql command on the remote
> database. Just run something like "SELECT 1" and check you actually
> get a 1 back, and not a connection error.
>
> > We'd be using FME to push data from other databases into PostgreSQL,
> however before running our FME scripts we'd want to check the DB is up and
> running. If the DB is running, then run the FME scripts, if not...don't run
> the FME scripts. All of this needs to be controlled via a windows server
> 2008 box.
> >
> > I appreciate your help.
> >
> > Regards
> >
> > Hugh
> >
> > -----Original Message-----
> > From: Dave Page [mailto:dpage(at)pgadmin(dot)org]
> > Sent: 15 August 2012 16:30
> > To: Bruce Momjian
> > Cc: Loughrey, Hugh; pgsql-general(at)postgresql(dot)org
> > Subject: Re: [GENERAL] Check PostgreSQL status using MS-DOS bat file?
> >
> > On Wed, Aug 15, 2012 at 4:04 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> >> 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.
> >
> > You shouldn't try to start/stop the server with pg_ctl if it's
> configured to run as a service (use "net start xxx", "net stop xxx"
> > for that), but you can check the status:
> >
> > C:\>"C:\Program Files\PostgreSQL\9.2\bin\pg_ctl.exe" -D "C:\Program
> Files\PostgreSQL\9.2\data" status
> > pg_ctl: server is running (PID: 1040)
> > C:/Program Files/PostgreSQL/9.2/bin/postgres.exe "-D" "C:/Program
> Files/PostgreSQL/9.2/data"
> >
> >
> > C:\>net stop postgresql-x64-9.2
> > The postgresql-x64-9.2 service is stopping.
> > The postgresql-x64-9.2 service was stopped successfully.
> >
> >
> > C:\>"C:\Program Files\PostgreSQL\9.2\bin\pg_ctl.exe" -D "C:\Program
> Files\PostgreSQL\9.2\data" status
> > pg_ctl: no server running
> >
> > --
> > Dave Page
> > Blog: http://pgsnake.blogspot.com
> > Twitter: @pgsnake
> >
> > EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL
> Company
> > “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.
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>