From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | Collin Peters <collinp(at)telus(dot)net> |
Cc: | "PostgreSQL General" <pgsql-general(at)hub(dot)org> |
Subject: | Re: SV: Postmaster startup problems |
Date: | 2000-10-08 22:18:18 |
Message-ID: | 4.3.2.7.2.20001008191319.04c44a00@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
> >
> >
From | Date | Subject | |
---|---|---|---|
Next Message | stephane | 2000-10-09 01:24:00 | MD5 hash function for PostgreSQL |
Previous Message | Charles Tassell | 2000-10-08 22:12:08 | Re: Trying to use PGSql with PHP |