Re: How to check postgres running or not ?

From: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
To: Arne Stoelck <stolck(at)web(dot)de>, Sandeep Gaikwad <sgaikwad(at)vertex(dot)co(dot)in>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to check postgres running or not ?
Date: 2004-09-20 13:46:07
Message-ID: 20040920134607.75051.qmail@web41004.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Funny... I set up a little program on my development
machine that queries for the rendezvous name. This way
I know my development machine is running before I try
to connect.

I think zeroconf could be used for this quite
easily...

JMHO

Ted

--- Arne Stoelck <stolck(at)web(dot)de> wrote:

>
> How about a simple
>
> " telnet localhost 5432 " ?
>
> assuming postmaster is listening on that host and
> port
>
>
> On Fri, 17 Sep 2004, Sandeep Gaikwad wrote:
>
> >
> > Hello Sir,
> > I want to know how to check whether
> postgres database is
> > running or not ? when I give command like
> ./postmaster -i &, whether all
> > databases in that postgres will run or any one
> [default] ? If any one, then
> > how to detect that database ?
> >
> > Thanks and regards,
> > Sandeep.
> >
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match
>


__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message T E Schmitz 2004-09-20 15:14:46 COUNT(*) to find records which have a certain number of dependencies ?
Previous Message Bruce Momjian 2004-09-20 12:34:27 Re: Implicit Transactions