Using Ambari with PostgreSQL

To set up PostgreSQL for use with Ambari:

Steps

On the Ambari Server host run:

ambari-server setup --jdbc-db=postgres --jdbc-driver=/path/to/postgres/postgresql.jar

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.