You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Siddharth Wagle (JIRA)" <ji...@apache.org> on 2014/05/01 19:21:14 UTC

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

     [ https://issues.apache.org/jira/browse/AMBARI-5650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Siddharth Wagle updated AMBARI-5650:
------------------------------------

    Attachment: AMBARI-5650.patch

> 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
>
>         Attachments: AMBARI-5650.patch
>
>
> 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)