You can do
ps axw |grep post
from a command prompt to make sure it's running (should see something like
" ...... /usr/local/pgsql/bin/postmaster ...."
You can then look for a file called /tmp/.s.PGSQL.#### where #### is the
port that postgres is running on, the default is 5432. If PostGres seems
to be running and using the default port, your best bet is to check the
pg_hba.conf file and make sure it has an entry for your local machine in
it. Try just adding the following line:
local all trust
The pg_hba.conf file is located in your data directory, usually
/usr/local/pgsql/data
At 04:30 PM 10/8/00, Collin Peters wrote:
>I am just trying to connect locally. Only one machine involved. Is
>there a way to tell what port the postmaster is running on if it is
>running at all.
>
>Collin
>
>On Sun, 8 Oct 2000 10:55:32 +0200, Jarmo Paavilainen said:
>
> >
> > ....
> > > I'm having problems starting postgres. What happens is
> > > that I start it but then it says it isn't running.
> > ....
> > > DEBUG: Data Base System is starting up at Sat Oct 7 13:13:29 2000
> > > DEBUG: Data Base System was shut down at Sat Oct 7 13:13:25 2000
> > > DEBUG: Data Base System is in production state at Sat Oct 7
> 13:13:29 2000
> > ....
> > > Which leads me to think that it is in fact running. But I can't
> > > connect!! Is it maybe running on a different port or
> something? Another
> >
> > From where are you trying to connect? If your not connecting locally you
> > must add the -i option to postmaster.
> >
> > // Jarmo
> >
> >