Changing PostgreSQL Port

Question

Level 1

100 points

Changing PostgreSQL Port

Is there a way to change postgresql to listen on a different port - NOT 8820? Ideally, I would like to change its listening port to 1433, but if I make the change in the postgresql.conf file, it is still listening on 8820. Any insight into this would be appreciated.

MacBook Pro 2.33 GHz, Mac OS X (10.5.7), and Windows 7

Posted on Sep 9, 2009 3:39 PM

Reply

Answer 1

Sep 9, 2009 5:05 PM in response to wilsonbyu

Can I ask why you wish to change the port?

Nicholas Stokes

Reply

Answer 2

wilsonbyu Author

Level 1

100 points

Sep 9, 2009 9:23 PM in response to Nicholas Stokes

I am tapping into the database from beyond a firewall that isn't managed by our organization and I'd rather not poke another hole in it. If I can change the port to a standard port like 1433, then I won't have to go through the hassle of getting them to open another port on the firewall.

Reply