Re: SV: Postmaster startup problems

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
> >
> >