lemmy/scripts/restore_db.sh

#!/usr/bin/env bash

psql -U lemmy -c "DROP SCHEMA public CASCADE; CREATE SCHEMA public;"
cat docker/lemmy_dump_2021-01-29_16_13_40.sqldump | psql -U lemmy
psql -U lemmy -c "alter user lemmy with password 'password'"
make shebangs posix compliant (#2974) Previously, these scripts wouldn't work on exotic systems such as NixOS. ``` fd '\.sh$' -t f --exec sed -i 's@#!/bin/bash@#!/usr/bin/env bash@' ``` 2023-06-08 19:38:26 +00:00			`#!/usr/bin/env bash`
~80% done 2021-03-10 22:33:55 +00:00
			`psql -U lemmy -c "DROP SCHEMA public CASCADE; CREATE SCHEMA public;"`
Combine prod and dev docker setups using build-arg (#2739) * Combine prod and dev docker setups using build-arg - Fixes #2603 * Dont use cache for release build. 2023-02-17 06:29:45 +00:00			`cat docker/lemmy_dump_2021-01-29_16_13_40.sqldump \| psql -U lemmy`
~80% done 2021-03-10 22:33:55 +00:00			`psql -U lemmy -c "alter user lemmy with password 'password'"`