How do I change port for the postmaster?

From: "Robert Wagner" <rwagner(at)siac(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: How do I change port for the postmaster?
Date: 1999-12-15 17:34:18
Message-ID: 85256848.005E8A52.00@SIAC_NOTES_001.wisdom.siac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm attempting to run two different postmasters on two different HP-UX
servers, servicing two different apps. The only commonality is that I'm on
one terminal.

The first starts up OK. When I attempt to start the postmaster on the
other server, I get the error,

FATAL: StreamServerPort: bind() failed: errno=226 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

Tried deleting the file, /tmp/.s.PGSQL.5432 but this had no effect.

Do I need to use a different port number, to run postmaster on two
different servers? If so, does anybody know how I can change the port
number? Is there something else, that I'm doing wrong?

I'm looking through the docs but can't find anything. I'd like to keep
postgres in the organization and avoid switching to (and learning) some big
commercial product like oracle!

Thanks!
Rob Wagner
Lowly Consultant,
SIAC

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Hoffmann 1999-12-15 17:35:20 Re: [GENERAL] server hardware recommendations (the archives aredead)
Previous Message Dan Linderman 1999-12-15 17:30:14 "Delete" table