postgresql new database port

[rogel]

hi! how do you create a new database server port? do you need to install postgresql again?

[ROCLASI]

Hi Rogel,

You can assign a different port to PostgreSQL by editing the postgresql.conf file. Ofcourse after this change you need to restart the PostgreSQL service.

Hope this helps.

[rogel]

Hi Rogel,

You can assign a different port to PostgreSQL by editing the postgresql.conf file. Ofcourse after this change you need to restart the PostgreSQL service.

Hope this helps.

Can we have 2 ports running on the same service?

[ROCLASI]

PostgreSQL itself can only use 1 port.
Why do you need multiple ports on the same service ? What benefit would that give you ?

[rogel]

PostgreSQL itself can only use 1 port.
Why do you need multiple ports on the same service ? What benefit would that give you ?

hi robert,

just for development.

[ROCLASI]

Hi Rogel,

Still then you don't need different ports in the same service.
You can do 2 things here:
1) setup 2 PostgreSQL instances each on their own port number running side by side.
2) use 1 PostgreSQL instance and have 1 set of developement databases and 1 set of deployment databases.
The connection names in Developer will be the same as the deployment server but the connection string will point to the dev db's instead.

Hope this helps.

[rogel]

Hi Rogel,

Still then you don't need different ports in the same service.
You can do 2 things here:
1) setup 2 PostgreSQL instances each on their own port number running side by side.
2) use 1 PostgreSQL instance and have 1 set of developement databases and 1 set of deployment databases.
The connection names in Developer will be the same as the deployment server but the connection string will point to the dev db's instead.

Hope this helps.

Thanks! I think I followed number 2.