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.

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

1 Answer 1

Reset to default
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
Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.