mirror of
https://github.com/dnote/dnote
synced 2026-03-14 22:45:50 +01:00
21 lines
867 B
Bash
Executable file
21 lines
867 B
Bash
Executable file
#!/usr/bin/env bash
|
|
set -ex
|
|
|
|
sudo apt-get install wget ca-certificates
|
|
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
|
|
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
|
|
|
|
sudo apt-get update
|
|
sudo apt-get install -y postgresql-14
|
|
|
|
# set up database
|
|
sudo usermod -a -G sudo postgres
|
|
cd /var/lib/postgresql
|
|
sudo -u postgres createdb dnote
|
|
sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'postgres';"
|
|
|
|
# allow connection from host and allow to connect without password
|
|
sudo sed -i "/port*/a listen_addresses = '*'" /etc/postgresql/14/main/postgresql.conf
|
|
sudo sed -i 's/host.*all.*.all.*md5/# &/' /etc/postgresql/14/main/pg_hba.conf
|
|
sudo sed -i "$ a host all all all trust" /etc/postgresql/14/main/pg_hba.conf
|
|
sudo service postgresql restart
|