File: init-postgres-db.sh

package info (click to toggle)
python-django-import-export 4.3.5-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 4,300 kB
  • sloc: python: 11,650; makefile: 180; sh: 63; javascript: 50
file content (9 lines) | stat: -rwxr-xr-x 401 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
 
#!/usr/bin/env bash
set -e

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    CREATE USER $IMPORT_EXPORT_POSTGRESQL_USER WITH PASSWORD '$IMPORT_EXPORT_POSTGRESQL_PASSWORD';
    CREATE DATABASE $DB_NAME ENCODING 'utf-8';
    GRANT ALL PRIVILEGES ON DATABASE $DB_NAME TO $IMPORT_EXPORT_POSTGRESQL_USER;
    ALTER USER $IMPORT_EXPORT_POSTGRESQL_USER CREATEDB;
EOSQL