duckil_plm/plm-timescaledb/init-scripts/00-init-user.sh
2024-12-19 11:59:04 +09:00

18 lines
552 B
Bash

# config/postgres/init-scripts/00-init-user.sh
#!/bin/bash
set -e
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
-- TimescaleDB 확장 활성화
CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;
-- 사용자 권한 설정
ALTER USER $POSTGRES_USER WITH PASSWORD '$POSTGRES_PASSWORD';
ALTER USER $POSTGRES_USER SET client_encoding TO 'utf8';
ALTER USER $POSTGRES_USER SET timezone TO 'UTC';
-- 데이터베이스 설정
ALTER DATABASE $POSTGRES_DB SET timezone TO 'UTC';
EOSQL