Question: Running different versions of postgresql side by side


Running different versions of postgresql side by side

Answers 1
Added at 2016-12-07 11:12

I have postgresql 9.3 installed. I would like to have also postgres 9.6.1 installed.

Each application is using a different DB. Most of the times I don't run both applications, so I don't need them to run concurrently.

I downloaded the installer recommended by postgres, and installed 9.6.1, but then it seems that 9.3 is not able to start anymore. I'm getting an error trying to run sudo service postgres start:

  • Starting PostgreSQL 9.3 database server
  • The PostgreSQL server failed to start. Please check the log output.

The log file is empty (not sure that's the interesting one) - /var/log/postgresql/postgresql-9.3-main.log

Any idea how to be able to run both instances?

nr: #1 dodano: 2016-12-07 12:12

You need to check the postgresql.conf config file.

If you want to run both instances at the same time then they will need to be run on different ports otherwise they will conflict. The default is 5432, change this for one of the DB's.

Then make sure that the data directory, log file are unique for each instance.

Source Show
◀ Wstecz