DocsHortonworks Data Platform

 

 1. Upgrade Failure with PostgreSQL

If you installed Ambari server with a PostgresQL database and upgrading Ambari Server using a remote or public repository failed, use the following steps to fix the upgrade.

  1. Upgrade the database schema.

    var/lib/ambari-server/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql

with the following parameters:
dbname = ambari
username = ambari

  2. Check database consistency.

    var/lib/ambari-server/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.Check.sql

with the following parameter:
dbname = ambari

  3. If you find an inconsistency, fix it using

    var/lib/ambari-server/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.Fix.sql
                        
with the following parameter:
dbname = ambari
Legal notices