| puthuparambil.aditya | f71e365 | 2021-08-18 13:57:24 +0100 | [diff] [blame] | 1 | #!/bin/bash |
| 2 | |
| 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 | |
| 21 | set -e |
| 22 | set echo on; |
| 23 | psql --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; |
| 28 | EOSQL |