From: | Lucas Possamai <drum(dot)lucas(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Shell script Postgres Running |
Date: | 2016-05-18 23:52:46 |
Message-ID: | CAE_gQfVJQiSiq4LHvYScQ3v2X+yRZnsw7HMEyWhvFEXJr=9rdQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
I'm writing a shell script to get the information if postgres is or is not
running.
#!/usr/bin/ksh
> # the path to the PID file
> PIDFILE=/var/lib/pgsql/9.2/data/postmaster.pid
> if [ -f $PIDFILE ] ; then
> PID=`cat $PIDFILE`
> if [ "x$PID" != "x" ] && kill -0 $PID 2>/dev/null ; then
> STATUS="There is a pidfile, YES, Postgres is running."
> else
> STATUS="There is no pidfile, Postgres is not running."
> fi
> else
> STATUS="There is no pidfile, Postgres is not running."
> fi
> echo $STATUS
The script above works.. But, is there any way to get the same information,
but with the checkpoints?
When you have a huge shared_buffer, when stopping the postgres' process, it
will take some time to get it running again, right? Because the server will
be writing a checkpoint?
So I'd like to check that... Is it possible?
Cheers
Lucas
From | Date | Subject | |
---|---|---|---|
Next Message | Keith | 2016-05-19 02:37:50 | Re: Shell script Postgres Running |
Previous Message | Mitra . | 2016-05-18 23:11:37 | Re: Error: extra data after last expected column |