Support Questions
Find answers, ask questions, and share your expertise

Ambari Server and Multiple Postgres versions?




I'm running into an issue related to a system that has two different versions of postgres installed. The system is running ambari and my intention is for to run ambari server with postgres v10. However I recently noticed it was running with verision 9.2. I could tell b/c the postgres 9.2 service was active while the postgresql-10 service was inactive. Back when I upgraded the system to ambari I confirmed it was up and running with postgres10 but after rebooting the machine I noticed it's now running with version 9.2. Is there an ambari configuration/setting that tells it which version of postgres to choose/run with? 


Re: Ambari Server and Multiple Postgres versions?



Simplest method is to edit /etc/postgresql/9.2/main/start.conf and replace auto with manual or disabled.


You can also resolve this by adding the following to the end of your shell's initialisation file (e.g. ~/.bashrc if you're using bash):


reboot the server  now you should have the postgres 10 as the default

Hope that helps

Re: Ambari Server and Multiple Postgres versions?


Thanks this is helpful, but I was curious. If there are versions of postgres installed on the system, how does ambari-server choose which one to run with? I actually have another system where I'm seeing the opposite. In this case postgresql-10 is running and postgresql (9.2) is not active after a restart. I'm just trying better understand how it choose which postgres service to start?