postmaster, but not pg_ctl -i -i

From: "Aurangzeb M(dot) Agha" <aagha(at)bigfoot(dot)com>
To: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: postmaster, but not pg_ctl -i -i
Date: 2002-11-14 10:46:53
Message-ID: Pine.LNX.4.44.0211140227540.2140-100000@cinemaspace.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm having an odd problem where I can start up postmaster just fine with
the following command:

$ /usr/local/pgsql/bin/postmaster -D .
DEBUG: database system was shut down at 2002-11-14 05:04:25 EST
DEBUG: checkpoint record is at 0/115894
DEBUG: redo record is at 0/115894; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 91; next oid: 16556
DEBUG: database system is ready

This also works fine if I do a pg_ctl without using the "-o -i" option, I
get the same.

No, I stop the postmaster that's running, do a 'ps -ef', and make sure NO
postmasters are running. Then, I execute:

$ pg_ctl -D . stop
pg_ctl: cannot find ./postmaster.pid
Is postmaster running?

$ pg_ctl start -D . -o -i
postmaster successfully started
FATAL: StreamServerPort: bind() failed: Address already in use
Is another postmaster already running on port 5432?
If not, wait a few seconds and retry.
/usr/local/pgsql/bin/postmaster: cannot create INET stream port

BUT, if I do:

$ postmaster -D . -o -i -p 5432
DEBUG: database system was shut down at 2002-11-14 05:35:49 EST
DEBUG: checkpoint record is at 0/115954
DEBUG: redo record is at 0/115954; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 91; next oid: 16556
DEBUG: database system is ready

Why is this happening? Why is pg_ctl behaving differently when I specify
"-o -i"? If I run pg_ctl without the -o -i options, it runs fine, so I'm
pretty sure that that's it. Also, I don't think it's a port issue,
otherwise postmaster would have the same problem on the 5432.

This issue was posted at:

http://archives.postgresql.org/pgsql-admin/1998-11/msg00044.php

And I checked my /tmp dir, but there's nothing there.

Any thoughts?

Thanks in Advance,
Aurangzeb

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2002-11-14 11:07:58 Re: Help..Help...
Previous Message Shridhar Daithankar 2002-11-14 10:28:17 Re: [GENERAL] Upgrade to dual processor machine?