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
986 Postings in 325 Threads, 327 registered users, 110 users online (0 registered, 110 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum