PDA

View Full Version : Postgres upgrade--what port number



hastijoe
04-04-2011, 11:02 AM
During install Postgress asks which port to listen on and defaults to 5433, but my current port number is 5432, which does allow me to connect to the database in HEM. Should I use the suggested port # or the existing one?

Patvs
04-04-2011, 10:23 PM
Default should be 5432.
If 5432 is occupied, it will use 5433.

Are you running multiple versions of PostgreSQL (8.3 and 8.4?)
It really doesn't matter which port is being used.
Just connect to the one that has your current database.

Edit: don't install two versions of PostgreSQL to both using the same port.
So if it suggests 5433 as default, just install it to 5433.