[jira] [Created] (AMBARI-5650) postgres-CREATE DDL should only prepare schemas if possible

[Siddharth Wagle (JIRA)]

Siddharth Wagle created AMBARI-5650:
---------------------------------------

             Summary: postgres-CREATE DDL should only prepare schemas if 
possible
                 Key: AMBARI-5650
                 URL: https://issues.apache.org/jira/browse/AMBARI-5650
             Project: Ambari
          Issue Type: Task
          Components: controller
    Affects Versions: 1.6.0
            Reporter: Siddharth Wagle
            Assignee: Myroslav Papirkovskyy
             Fix For: 1.6.0


For existing postgres, the user should execute DDL as part of setting up their 
postgres instance.

{code}
CREATE SCHEMA ambari AUTHORIZATION :username;
ALTER ROLE :username SET search_path TO 'ambari';
{code}

This is similar to setup of mysql and oracle.




--
This message was sent by Atlassian JIRA
(v6.2#6252)