[postgres@yz219 ~]$ psql -d postgres
postgres=# CREATE DATABASE ambari;
postgres=# CREATE USER ambari WITH PASSWORD 'bigdata';
postgres=# GRANT ALL PRIVILEGES ON DATABASE ambari TO ambari;
postgres=# \connect ambari;
ambari=# CREATE SCHEMA ambari AUTHORIZATION ambari;
ambari=# ALTER SCHEMA ambari OWNER TO ambari;
ambari=# ALTER ROLE ambari SET search_path to 'ambari', 'public';