Re: How to check postgres running or not ? - Mailing list pgsql-sql

From Christopher Browne
Subject Re: How to check postgres running or not ?
Date
Msg-id m3llf5pvw3.fsf@wolfe.cbbrowne.com
Whole thread Raw
In response to How to check postgres running or not ?  ("Sandeep Gaikwad" <sgaikwad@vertex.co.in>)
Responses Test for file exists?  ("Richard Sydney-Smith" <richard@ibisaustralia.com>)
List pgsql-sql
Clinging to sanity, worik@noggon.com (Worik) mumbled into her beard:
> [snip]
>> Just to enforce the test is better looking for the entire executable
>> path:
>>         ps aux | grep /usr/bin/postmaster | grep -v grep
>>
>
> Does not work for me!
>
> worik@stolberg:~$ ps aux | grep /usr/bin/postmaster | grep -v grep
> worik@stolberg:~$ ps aux | grep postmaster | grep -v grep
> postgres   670  0.1  0.6  8544 1688 pts/1    S    12:33   0:00
> /usr/lib/postgresql/bin/postmaster
> worik@stolberg:~$
>
> So...
> " ps aux | grep postmaster | grep -v grep "
> is more reliable(?)

There's a very slightly clever modification that gets rid of the extra
grep...

Try.. 
[appropriate ps command for your platform] | egrep '[p]ostmaster'

That egrep _won't_ match its own command line.
-- 
let name="cbbrowne" and tld="ntlug.org" in String.concat "@" [name;tld];;
http://www3.sympatico.ca/cbbrowne/multiplexor.html
He doesn't have much of a reputation, or so I've heard. 


pgsql-sql by date:

Previous
From: Arne Stoelck
Date:
Subject: Re: How to check postgres running or not ?
Next
From: "Richard Sydney-Smith"
Date:
Subject: Test for file exists?