@vinay kumar
You have upgraded the PostgresSQL to 9.3, But do you see that the "ambari" DB still exist there?
Please check if you see the Ambari DB Tables there? # psql -U ambari ambari
Password for user ambari: bigdata
psql (9.5.5)
Type "help" for help.
ambari=> \dt+ If the Postgres SQL 9.3 has the ambari DB (upgraded from Postgres SQL 8.1) then you shoudl see all the existing tables and data.
Now If the postgressql hostname or port is changed during upgrade then you shoudl run the "smbari-server setup" again and this time you should choose the "" option and say "y" Enter advanced database configuration [y/n] (n)? y
And then choose the hostname & port properly and do nto use the "[1] - PostgreSQL (Embedded)" option while setup else ambari will try to reinitialize the DB and as the Ambari DB already exist so it might cause issues. You should choose Option [4] - PostgreSQL
Example: (Before doing the ambari-server setup again Please take Ambari DB dump and keep safely)
# ambari-server setup
Using python /usr/bin/python
Setup ambari-server
Checking SELinux...
SELinux status is 'enabled'
SELinux mode is 'permissive'
WARNING: SELinux is set to 'permissive' mode and temporarily disabled.
OK to continue [y/n] (y)? y
Customize user account for ambari-server daemon [y/n] (n)? y
Enter user account for ambari-server daemon (root):
Adjusting ambari-server permissions and ownership...
Checking firewall status...
Checking JDK...
Do you want to change Oracle JDK [y/n] (n)? n
Completing setup...
Configuring database...
Enter advanced database configuration [y/n] (n)? y
Configuring database...
==============================================================================
Choose one of the following options:
[1] - PostgreSQL (Embedded)
[2] - Oracle
[3] - MySQL / MariaDB
[4] - PostgreSQL
[5] - Microsoft SQL Server (Tech Preview)
[6] - SQL Anywhere
[7] - BDB
==============================================================================
Enter choice (4): 4
Hostname (standaloneambari.example.com): standaloneambari.example.com
Port (5432):
Database name (ambari):
Postgres schema (ambari):
Username (ambari):
Enter Database Password (bigdata):
Configuring ambari database...
Configuring remote database connection properties...
WARNING:
Before starting Ambari Server, you must run the following DDL against
the database to create the schema:
/var/lib/ambari-server/resources/Ambari-DDL-Postgres-CREATE.sql
Proceed with configuring remote database connection properties [y/n] (y) .
... View more
