0

I have recently upgraded from Debian 7 to Debian 8 and from PostgreSQL 9.1 to 9.4. I am not able to connect to my database server even from pgAdmin III on localhost.

I have in my postgresql.conf the port as 5433 and the listen_address as "*".

In pg_hba.conf, I have the following lines: host all all 127.0.0.1/32 md5 host all all ::1/128 md5

Nonetheless, I get the following error when I try to connect:

enter image description here

What configuration have I not yet configured? I believe I went through the same procedure in the config files as when I set up in 9.1, but it is not working.

7
  • What says netstat -anp | grep 5433 ?
    – krisFR
    May 15, 2015 at 20:35
  • @krisFR no output
    – Jake
    May 15, 2015 at 20:36
  • So what says netstat -anp | grep -i postgre ?
    – krisFR
    May 15, 2015 at 20:38
  • No output. I made sure it was started first too.
    – Jake
    May 15, 2015 at 20:53
  • 1
    It is not started.
    – krisFR
    May 15, 2015 at 20:53

1 Answer 1

0

The message you highlighted on the screenshot clearly states that the server did not start. Your pg_hba.conf looks syntactically correct, so I doubt it is the issue. You need to examine the logs. Most probably you forgot to perform the upgrade and the server refuses to start upon detecting old data format.

You should check the logs for something like the following:

Sep 02 18:11:03 localhost.localdomain postgresql-check-db-dir[30673]: An old version of the database format was found.
Sep 02 18:11:03 localhost.localdomain postgresql-check-db-dir[30673]: Use "postgresql-setup --upgrade" to upgrade to version 9.4.

If this is indeed the case then you need to run:

postgresql-setup --upgrade

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .