From 0b52d52f4aee4484c272a7bce21b7286115234e5 Mon Sep 17 00:00:00 2001 From: Sandro Jäckel Date: Sun, 31 May 2020 10:02:05 +0200 Subject: Use inbuilt init script --- docker/init-invidious-db.sh | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100755 docker/init-invidious-db.sh (limited to 'docker/init-invidious-db.sh') diff --git a/docker/init-invidious-db.sh b/docker/init-invidious-db.sh new file mode 100755 index 00000000..c07c7770 --- /dev/null +++ b/docker/init-invidious-db.sh @@ -0,0 +1,12 @@ +#!/bin/sh +set -eou pipefail + +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 -- cgit v1.2.3 From e16d951da059c1a82eba7532b8a28dc51bcb7e21 Mon Sep 17 00:00:00 2001 From: Sandro Jäckel Date: Thu, 4 Jun 2020 08:10:30 +0200 Subject: Create postgres user to avoid fatal warning --- docker/init-invidious-db.sh | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'docker/init-invidious-db.sh') diff --git a/docker/init-invidious-db.sh b/docker/init-invidious-db.sh index c07c7770..6c8ad3a7 100755 --- a/docker/init-invidious-db.sh +++ b/docker/init-invidious-db.sh @@ -1,6 +1,10 @@ #!/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 -- cgit v1.2.3 From ccbbe81141665a41490041eb84e7c6c4f7c437cd Mon Sep 17 00:00:00 2001 From: resttime Date: Wed, 19 Aug 2020 13:36:35 -0500 Subject: Use bash in the shebang --- docker/init-invidious-db.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'docker/init-invidious-db.sh') diff --git a/docker/init-invidious-db.sh b/docker/init-invidious-db.sh index 6c8ad3a7..3808e673 100755 --- a/docker/init-invidious-db.sh +++ b/docker/init-invidious-db.sh @@ -1,4 +1,4 @@ -#!/bin/sh +#!/bin/bash set -eou pipefail psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL -- cgit v1.2.3