Re: SV: Postmaster startup problems - Mailing list pgsql-general

Charles, I tried what you said with the following output:

ps axw|grep post has the output:
collin@the-kernel:~$ ps axw|grep post
 6311 pts/2    S      0:00 /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data
 6336 pts/3    S      0:00 grep post

There IS a file in the /tmp directory named '.s.PGSQL.5432' which means
that it is running on port 5432, correct?
There already was an entry in the pg_hba.conf file with 'local all trust'

I renamed my pgsql directory and recompiled postgres but it still does
the exact same thing.  Any other ideas?

Here is a screenshot so you know exactly what I'm doing:
http://www3.telus.net/cadiolis/shots/postgres.jpg
I logged in on the left terminal and started the database, then logged
into the right terminal and tried to start psql
I've also started the database from the actual cli and not a terminal
window with no luck..


Collin


On Sun, 08 Oct 2000 19:18:18 -0300, Charles Tassell said:

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