Running different versions of postgresql side by side

Question

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?

@VaoTsun /opt/PostgreSQL/9.6/bin/pg_ctl /usr/bin/pg_ctlcluster /usr/lib/postgresql/9.3/bin/pg_ctl — Elad Tabak
– Elad Tabak, Commented Dec 7, 2016 at 10:12

Gurmokh · Accepted Answer · 2016-12-07 11:31:23Z

2

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.

answered Dec 7, 2016 at 11:31

Gurmokh

2,09127 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Elad Tabak Over a year ago

It's not only the DB. For example when running this command I'm getting an error:

Gurmokh Over a year ago

can you provide example of what you are doing ?

Elad Tabak Over a year ago

One use case would be testing upgrade DB from older version to new one

Collectives™ on Stack Overflow

Running different versions of postgresql side by side

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related