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