SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Upgraded Postgres: changed port number, not able to connect (General)

posted by Brian Dunn(R), 03.06.2015, 17:40

I have Postgres 9 running on a non-default port as the default was used by
Postgres 8.

On my system, I only keep the newer version of Postgres. The newer version installs with a new port (5433 in my case), as you have seen, while the older version still uses the default (5432 in my case).

When the new version of Postgres was installed, hopefully the clusters were upgraded at that time. If not, do so now.

Verify that psql can see the new database in the new Postgres.

Remove the older version of Posgres.

Edit postgresql.conf to make port = 5432


Complete thread:

Back to the forum
Board view  Mix view
1007 Postings in 335 Threads, 363 registered users, 108 users online (0 registered, 108 guests)
SQL-Ledger User Forum | Admin contact
powered by my little forum