I tried the pg_upgrade and it was successful. But still the ambari server is not starting it gives the same error. Updated the systemb unit files with the new data directory. But still it didn't help to start ambari. Is there any way to find out that ambari server is using the new updated postgres(9.6)?   If I run this command to start postgresql /usr/pgsql-9.6/bin/postgres -D /var/lib/pgsql/9.6/data/ It gives the following error message not sure is this normal.   < 2020-05-09 18:10:45.674 UTC > LOG: redirecting log output to logging collector process < 2020-05-09 18:10:45.674 UTC > HINT: Future log output will appear in directory "pg_log". I tired giving enter multiple times it stays on this and not coming out. The pg_log says like this   < 2020-05-09 18:10:45.677 UTC > LOG: MultiXact member wraparound protections are now enabled < 2020-05-09 18:10:45.679 UTC > LOG: database system is ready to accept connections < 2020-05-09 18:10:45.679 UTC > LOG: autovacuum launcher started   If the postgresql server is started but the ambari is not coming up. My goal is to update postgres to 9.6 and make ambari to use this version.   My assumption is that postgres upgrade is sucessfull but the ambari service start is not happening. ... View more

Still the ambari server is not starting it failed in starting postgresql service this is the error log ERROR 2020-05-09 08:40:02,291 ambari-server.py:997 - 'Fatal exception: Unable to start PostgreSQL server. Status stopped. . Exiting, exit code 3' Traceback (most recent call last): File "/usr/sbin/ambari-server.py", line 980, in main action_obj.execute() File "/usr/sbin/ambari-server.py", line 79, in execute self.fn(*self.args, **self.kwargs) File "/usr/lib/ambari-server/lib/ambari_commons/os_family_impl.py", line 89, in thunk return fn(*args, **kwargs) File "/usr/sbin/ambari-server.py", line 130, in start server_process_main(args) File "/usr/sbin/ambari_server_main.py", line 329, in server_process_main ensure_dbms_is_running(options, properties, scmStatus) File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration.py", line 603, in ensure_dbms_is_running dbms.ensure_dbms_is_running(options, properties, scmStatus) File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration_linux.py", line 447, in ensure_dbms_is_running raise FatalException(retcode, err) FatalException: 'Fatal exception: Unable to start PostgreSQL server. Status stopped. . Exiting, exit code 3'   One more thing after the postgres upgrade I tried editing the file /usr/lib/systemd/system/postgresql.service also tried reloading the daemon(systemctl daemon-reload). I adjusted the bin and data location as follows.   # Location of database directory Environment=PGDATA=/var/lib/pgsql/9.6/data # Where to send early-startup messages from the server (before the logging # options of postgresql.conf take effect) # This is normally controlled by the global default set by systemd # StandardOutput=syslog # Disable OOM kill on the postmaster OOMScoreAdjust=-1000 ExecStartPre=/usr/pgsql-9.6/bin/postgresql-check-db-dir ${PGDATA} ExecStart=/usr/pgsql-9.6/bin/pg_ctl start -D ${PGDATA} -s -o "-p ${PGPORT}" -w -t 300 ExecStop=/usr/pgsql-9.6/bin/pg_ctl stop -D ${PGDATA} -s -m fast ExecReload=/usr/pgsql-9.6/bin/pg_ctl reload -D ${PGDATA} -s   Still the ambari failed to start with the same error.   Is this because the version is not compatiable or I'm doing anything wrong here. Is there any proper way for upgrading the postgresql version on the ambari server via yum??     ... View more

Thanks for the response. I tried starting the service but still I'm getting the following error while starting postgresql.   /usr/pgsql-9.6/bin/pg_ctl start -D /var/lib/pgsql/9.6/data/ server starting -bash-4.2$ LOG: skipping missing configuration file "/var/lib/pgsql/9.6/data/postgresql.auto.conf" FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 9.2, which is not compatible with this version 9.6.17.       ... View more