Different Port for PostgreSQL? - Mailing list pgsql-general

From Dan Ostrowski
Subject Different Port for PostgreSQL?
Date
Msg-id 003401c2632b$c5b7dd20$0200000a@dan
Whole thread Raw
In response to delete operation with "where XXX in"  ("Peter Alberer" <h9351252@obelix.wu-wien.ac.at>)
Responses Re: Different Port for PostgreSQL?
List pgsql-general
Hello all...
 
I am developing a databasing system that will be used localy, but in tandem with a hosted web server.
 
As such, I will be implementing a local PostgreSQL server and connecting it to the internet.  However, this machine ( unfortunately ) will probably also have to run the firewall as well, but that's all it will be more than likely.. database and firewall.
 
Ideally, I would be able to send a "REJECT" message ( via iptables ) if the connection is refused because the Database is down or somesuch, instead of just "DROP"ing the connection. This would speed up things for the web scripts when the DB is unreachable locally.  However, port scans will then be able to easily figure out that I am running PostgreSQL on the standard port, presumably.
 
Is there a way to run Postgre on some other non-standard port? Does it do well in this regard?  How would i go about doing that?
 
I know it won't "hack proof" anything really, just make it a bit more confusing for anyone doing port scans on my machine.
 
ideas?
 
 
regards,
dan

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: delete operation with "where XXX in"
Next
From: Joe Conway
Date:
Subject: Re: DBLink: interesting issue