PostgreSQL Prerequisite
The Ranger database user in Amazon RDS PostgreSQL Server should be created before installing Ranger and should be granted an existing role which must have the role CREATEDB.
Using the master user account, log in to the Amazon RDS PostgreSQL Server from master user account (created during RDS PostgreSQL instance creation) and execute following commands:
CREATE USER
$rangerdbuser
WITH LOGIN PASSWORD 'password
'GRANT
$rangerdbuser
to$postgresroot
Where
is the RDS PostgreSQL master user account (for example: postgresroot) and$postgresroot
is the Ranger database user name (for example: rangeradmin).$rangerdbuser
If you are using Ranger KMS, execute the following commands:
CREATE USER
$rangerkmsuser
WITH LOGIN PASSWORD 'password
'GRANT
$rangerkmsuser
to$postgresroot
Where
is the RDS PostgreSQL master user account (for example: postgresroot) and$postgresroot
is the Ranger KMS user name (for example: rangerkms).$rangerkmsuser