[
https://issues.apache.org/jira/browse/AMBARI-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alejandro Fernandez reassigned AMBARI-6409:
-------------------------------------------
Assignee: Alejandro Fernandez
> Postgres create script generates errors for clusterconfig
> ---------------------------------------------------------
>
> Key: AMBARI-6409
> URL: https://issues.apache.org/jira/browse/AMBARI-6409
> Project: Ambari
> Issue Type: Bug
> Components: build
> Affects Versions: 1.7.0
> Reporter: Alejandro Fernandez
> Assignee: Alejandro Fernandez
> Fix For: 1.7.0
>
>
> Manually running the postgres create sql script encountered errors.
> Errors:
> * psql:Ambari-DDL-Postgres-CREATE.sql:22: ERROR: column "config_attributes"
> specified more than once
> * psql:Ambari-DDL-Postgres-CREATE.sql:103: ERROR: relation "clusterconfig"
> does not exist
> * psql:Ambari-DDL-Postgres-CREATE.sql:126: ERROR: relation "clusterconfig"
> does not exist
> Repro Steps:
> 1. Spin up a CentOS 6.4 VM
> * vagrant up c6401
> * vagrant ssh c6401
> * sudo su -
> * wget
> http://public-repo-1.hortonworks.com/ambari/centos6/1.x/updates/1.6.0/ambari.repo
> * cp ambari.repo /etc/yum.repos.d
> * yum install ambari-server -y
> 2. Setup a postgres database
> * vi /etc/yum.repos.d/CentOS-Base.repo
> * edit the [base] and [updates] sections by adding the following line
> without quotes, "exclude=postgresql*"
> * yum localinstall
> http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm
> * yum install postgresql-server
> * cd /etc/yum.repos.d/
> * service postgresql initdb
> * chkconfig postgresql on
> * service postgresql start
> 3. Run the script
> * cp /vagrant/Ambari-DDL-Postgres-CREATE.sql
> /var/lib/ambari-server/resources/ (assuming you have the latest file from
> trunk)
> * cp /var/lib/ambari-server/resources/Ambari-DDL-Postgres-CREATE.sql
> /var/lib/pgsql/
> * su - postgres
> * psql
> * Follow step #1 at
> http://docs.hortonworks.com/HDPDocuments/Ambari-1.6.0.0/bk_ambari_reference/content/nndb-using-ambari-postgresql.html
> where $AMBARIDATABASE is ambari, $AMBARIUSER is postgres, and $AMBARISCHEMA
> is ambari.
> * \i Ambari-DDL-Postgres-CREATE.sql;
>
> Then verify the errors. When done, issue \q on the psql command line to exit.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
