1.3. Using Ambari with PostgreSQL

To set up PostgreSQL for use with Ambari:

Create a user for Ambari and grant it permissions.

Using the PostgreSQL database admin utility:

# sudo -u postgres psql
CREATE DATABASE $AMBARIDATABASE;
CREATE USER $AMBARIUSER WITH PASSWORD ‘$AMBARIPASSWORD’;
GRANT ALL PRIVILEGES ON DATABASE $AMBARIDATABASE TO $AMBARIUSER;
\connect $AMBARIDATABASE;
CREATE SCHEMA $AMBARISCHEMA AUTHORIZATION $AMBARIUSER;
ALTER SCHEMA $AMBARISCHEMA OWNER TO $AMBARIUSER;
ALTER ROLE $AMBARIUSER SET search_path to ‘$AMBARISCHEMA’, 'public';

Where $AMBARIUSER is the Ambari user name, $AMBARIPASSWORD is the Ambari user password, $AMBARIDATABASE is the Ambari database name and $AMBARISCHEMA is the Ambari schema name.

Load the Ambari Server database schema.
- You must pre-load the Ambari database schema into your PostgreSQL database using the schema script.
```
# psql -U $AMBARIUSER -d $AMBARIDATABASE
\connect $AMBARIDATABASE;
\i Ambari-DDL-Postgres-CREATE.sql;
```
- Find the Ambari-DDL-Postgres-CREATE.sql file in the /var/lib/ambari-server/resources/ directory of the Ambari Server host after you have installed Ambari Server.
When setting up the Ambari Server, select Advanced Database Configuration > Option [4] PostgreSQL and enter the credentials you defined in Step 2. for user name, password and database name.

Legal notices