diff options
Diffstat (limited to 'ansible/roles/ansible-vvp-templates/files/configmaps/postgresql-initdb-configmap.yaml')
-rw-r--r-- | ansible/roles/ansible-vvp-templates/files/configmaps/postgresql-initdb-configmap.yaml | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/ansible/roles/ansible-vvp-templates/files/configmaps/postgresql-initdb-configmap.yaml b/ansible/roles/ansible-vvp-templates/files/configmaps/postgresql-initdb-configmap.yaml new file mode 100644 index 0000000..e6f272e --- /dev/null +++ b/ansible/roles/ansible-vvp-templates/files/configmaps/postgresql-initdb-configmap.yaml @@ -0,0 +1,61 @@ +# -*- encoding: utf-8 -*- +# ============LICENSE_START======================================================= +# org.onap.vvp/engagementmgr +# =================================================================== +# Copyright © 2017 AT&T Intellectual Property. All rights reserved. +# =================================================================== +# +# Unless otherwise specified, all software contained herein is licensed +# under the Apache License, Version 2.0 (the “License”); +# you may not use this software except in compliance with the License. +# You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. +# +# +# +# Unless otherwise specified, all documentation contained herein is licensed +# under the Creative Commons License, Attribution 4.0 Intl. (the “License”); +# you may not use this documentation except in compliance with the License. +# You may obtain a copy of the License at +# +# https://creativecommons.org/licenses/by/4.0/ +# +# Unless required by applicable law or agreed to in writing, documentation +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. +# +# ============LICENSE_END============================================ +# +# ECOMP is a trademark and service mark of AT&T Intellectual Property. +--- +kind: ConfigMap +apiVersion: v1 +metadata: + name: postgresql-initdb + namespace: default +data: + # docker-entrypoint.sh supports sql scripts but we need to expand variables. + cms_db.sh: | + # sourced, not executed, by docker-entrypoint.sh (/bin/bash) + + # defaults + : ${ICE_CMS_DB_USER:="icecmsuser"} + : ${ICE_CMS_DB_NAME:="icecmsdb"} + : ${ICE_CMS_DB_PASSWORD:="na"} + + psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<- EOF + CREATE USER ${ICE_CMS_DB_USER} WITH CREATEDB PASSWORD '${ICE_CMS_DB_PASSWORD}'; + CREATE DATABASE ${ICE_CMS_DB_NAME} WITH OWNER ${ICE_CMS_DB_USER} ENCODING 'utf-8'; + EOF + link_postgresql.sh: | + # sourced, not executed, by docker-entrypoint.sh (/bin/bash) + ln -sf /etc/postgresql/conf.d/postgresql.conf "${PGDATA}"/postgresql.conf |