Postmaster startup problems

From: Collin Peters <collinp(at)telus(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Postmaster startup problems
Date: 2000-10-07 15:51:42
Message-ID: 20001007225839.CRMI20445.priv-edtnes04-hme0.telusplanet.net@the-kernel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm having problems starting postgres. What happens is that I start it
but then it says it isn't running.

In one terminal window:
postgres(at)the-kernel:~$ postmaster -D /usr/local/pgsql/data/
>$HOME/pm.log
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

In another terminal window while still looking at postmaster 'running' in
the other:
postgres(at)the-kernel:~$ psql
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?

If I try to start postmaster again:
postgres(at)the-kernel:~$ postmaster -D /usr/local/pgsql/data/
>$HOME/pm.log
FATAL: StreamServerPort: bind() failed: Address already in use
Is another postmaster already running on that port?
If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
/usr/local/pgsql/bin//postmaster: cannot create UNIX stream port

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
strange thing is that TOP reports the running process to be
/usr/local/pgsql/bin instead of /usr/local/pgsql/bin/postmaster which is
the way I remember it running before.

Collin Peters

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jack 2000-10-07 16:59:53 PostgreSQL 7.0
Previous Message Jan Wieck 2000-10-07 11:44:20 Re: Need help : Weird referencial Integrity triggers