Configuring a PostgreSQL database for Atlas

To use PostgreSQL as the backend metadata store for Apache Atlas, you must create a dedicated database and user before installing the Atlas service.

By default, Atlas uses HBase to store its JanusGraph metadata. If you choose to use PostgreSQL instead, you must provision the database and credentials beforehand. Cloudera Manager uses these credentials to initialize the required schema during the Atlas service installation.

Log in to your PostgreSQL database server as an administrator, for example, the postgres user.
```
sudo -u postgres psql
```
Create a dedicated database for Atlas.
```
CREATE DATABASE atlas;
```
Create a user for the Atlas service and set a strong password.
```
CREATE USER atlas WITH PASSWORD '[***PASSWORD***]';
```
Grant all privileges on the new database to the Atlas user.
```
GRANT ALL PRIVILEGES ON DATABASE atlas TO atlas;
```
Connect to the new Atlas database.
```
\c atlas
```
Grant all privileges on the public schema to the public role.
```
GRANT ALL ON SCHEMA public TO public;
```

The PostgreSQL database is ready. When you add the Atlas service in Cloudera Manager, select the PostgreSQL backend option and provide the database hostname, port, database name, username, and password.

Continue with Installing Atlas using Add Service.