PostgreSQL script to keep postgreSQL server running

-

:loop

@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

IF %RES% EQU ping (echo "Postgres running... ") else (echo "PostgreSQL seems not pinging.. Restarting..."
sc start postgreSQL-9.1 > NUL
)

ping -n 10 127.0.0.1 > NUL

goto loop

Comments

Post a Comment

Popular posts from this blog

Morning Quotes

-
Image
Source: www.brainyquote.com   I may be drunk, Miss, but in the morning I will be sober and you will still be ugly. Winston Churchill   Prayer is the key of the morning and the bolt of the evening. Mohandas Gandhi   I look upon death to be as necessary to our constitution as sleep. We shall rise refreshed in the morning. Benjamin Franklin  
Read more

QCalendarWidget CSS Stylesheeting

-
Recently I had to implement a calendar for a TouchScreen application. I resorted to css to modify the calendar widget's appearance so that it would be more accessible. Following is the code that enabled me to get a proper calendar. calendar->setStyleSheet("QMenu { font-size:20px; width: 300px; left: 20px; }"     "QToolButton {icon-size: 48px, 48px; font: 20px; height: 70px; width: 100px; }"     "QAbstractItemView {selection-background-color: rgb(255, 174, 0);}"     "QToolButton::menu-indicator{ width: 50px;}"     "QToolButton::menu-indicator:pressed,"     "QToolButton::menu-indicator:open{ top:10px; left: 10px;}"     "QTableView { font: 30px; }"     "QSpinBox { width: 100px; font: 20px;}"     "QSpinBox::up-button { width:40px;}"     "QSpinBox::down-button { width:40px;}");
Read more

A tryst with Message Queues Pt. 2

-
So far... I'm sending data to a RabbitMQ broker as messages. These messages get queued up in a user configurable queue. Supposedly a consumer is going to process these. But the consumer is out of my view. Doesn't matter. Now there came a feature of receiving notifications from the consumer or some other system. So after some discussion, the powers to be decided that we are going to have a notification queue which the client has to read. And from it we get the notifications to be read. Now the shady part of business was I had no idea what the hell is going on the inside of libStomp. So I ask politely that I don't have any read code. And I get handed over a single stomp_read code snippet. (In whiny voice) They said it works!!! But it doesn't!!! I tried so hard!!! Damn!!! So I looked into the protocol to understand why the hell I am no getting anything. After reading the protocol, I came to know that the implementation is fucked up in ways more than a few. First ...
Read more