diff options
| author | Perflyst <mail@perflyst.de> | 2020-08-03 17:09:51 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-08-03 17:09:51 +0200 |
| commit | 0ad974c57b931f2b9bb97de8295d2e68fce61a6d (patch) | |
| tree | 884f273142777e991ceefe94cc4c86175e406fb5 /docker/init-invidious-db.sh | |
| parent | 62f015fc34194979ef2cbb5bfef2f8df608177bc (diff) | |
| parent | e16d951da059c1a82eba7532b8a28dc51bcb7e21 (diff) | |
| download | invidious-0ad974c57b931f2b9bb97de8295d2e68fce61a6d.tar.gz invidious-0ad974c57b931f2b9bb97de8295d2e68fce61a6d.tar.bz2 invidious-0ad974c57b931f2b9bb97de8295d2e68fce61a6d.zip | |
Merge pull request #1211 from SuperSandro2000/improve-postgres
Improve postgres Dockerfile
Diffstat (limited to 'docker/init-invidious-db.sh')
| -rwxr-xr-x | docker/init-invidious-db.sh | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/docker/init-invidious-db.sh b/docker/init-invidious-db.sh new file mode 100755 index 00000000..6c8ad3a7 --- /dev/null +++ b/docker/init-invidious-db.sh @@ -0,0 +1,16 @@ +#!/bin/sh +set -eou pipefail + +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL + CREATE USER postgres; +EOSQL + +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/channels.sql +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/videos.sql +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/channel_videos.sql +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/users.sql +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/session_ids.sql +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/nonces.sql +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/annotations.sql +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/playlists.sql +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/playlist_videos.sql |