![]() ![]() Still the ambari server is not starting it failed in starting postgresql service this is the error logĮRROR 08:40:02,291 ambari-server.py:997 - 'Fatal exception: Unable to start PostgreSQL server. My assumption is that postgres upgrade is sucessfull but the ambari service start is not happening. My goal is to update postgres to 9.6 and make ambari to use this version. If the postgresql server is started but the ambari is not coming up. LOG: database system is ready to accept connections LOG: MultiXact member wraparound protections are now enabled I tired giving enter multiple times it stays on this and not coming out. ![]() HINT: Future log output will appear in directory "pg_log". LOG: redirecting log output to logging collector process 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. Is there any way to find out that ambari server is using the new updated postgres(9.6)? But still it didn't help to start ambari. Updated the systemb unit files with the new data directory. But still the ambari server is not starting it gives the same error. I tried the pg_upgrade and it was successful. I have a doubt that still its using the old version when I give yum list postgresql it shows only the 9.2.4 version as installed.Ĭan anyone help on this issue I fighting with this for 2 days. I have the doubt that is the upgrade properly done I mean the ambari server is using the 9.6 postgresql version that we installed. The DB restoration done but still while starting the ambari server I'm getting the error Ident authentication failed for user "ambari" usr/pgsql-9.6/bin/psql -d postgres -f outputfile Once the service was up I restored the DB with the following command: ![]() usr/pgsql-9.6/bin/pg_ctl start -D /var/lib/pgsql/9.6/data Started the postgres service with the following command: Restored the old pg_hba.conf and nf files from the backup directory. I ran the initdb command to create the cluster. Yum install postgresql96-server postgresql96.Īfter the installation the new directory got created /var/lib/pgsql/9.6/. Updated the postgres with the following command : Once the backup is done I stopped the service and Rename the pgsql directory under /var/lib/pgsql/ Took backup of the DB with following command. I'm trying to update the PostgreSQL from 9.2.24 to 9.6. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |