blob: 9cc0f5ff9fe211ffced26473d08541c9545f0636 [file] [log] [blame]
Guillaume Lambert85b14922021-03-12 13:53:18 +01001#!/bin/sh
puthuparambil.adityaf71e3652021-08-18 13:57:24 +01002
3# ============LICENSE_START=======================================================
4# Copyright (c) 2021 Bell Canada.
5# ================================================================================
6# Licensed under the Apache License, Version 2.0 (the "License");
7# you may not use this file except in compliance with the License.
8# You may obtain a copy of the License at
9
10# http://www.apache.org/licenses/LICENSE-2.0
11
12# Unless required by applicable law or agreed to in writing, software
13# distributed under the License is distributed on an "AS IS" BASIS,
14# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
15# See the License for the specific language governing permissions and
16# limitations under the License.
17#
18# SPDX-License-Identifier: Apache-2.0
19# ============LICENSE_END=========================================================
20
21set -e
22set echo on;
23psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
24 CREATE USER $DB_USERNAME WITH PASSWORD '$DB_PASSWORD';
25 CREATE SCHEMA $POSTGRES_DB;
26 GRANT ALL PRIVILEGES ON SCHEMA $POSTGRES_DB TO $DB_USERNAME;
27 CREATE EXTENSION IF NOT EXISTS timescaledb WITH SCHEMA $POSTGRES_DB;
28EOSQL