From ec64491435adb0f1cbf71f877877dd795ce5d621 Mon Sep 17 00:00:00 2001 From: Will Budicm Date: Sat, 5 Dec 2020 12:18:41 +1100 Subject: [PATCH] dbi:PG string for expected user defaults. --- Installation_ProgresSQL.txt | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/Installation_ProgresSQL.txt b/Installation_ProgresSQL.txt index 83fbd5a..c3474b1 100644 --- a/Installation_ProgresSQL.txt +++ b/Installation_ProgresSQL.txt @@ -50,9 +50,10 @@ sudo apt install libpq-dev sudo cpan DBD::Pg; -# To assign default Postgres SQL user and test db +# To assign default Postgres SQL user roles. sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'postgres';" -sudo -u postgres psql -c "CREATE DATABASE testdb;" +sudo -u postgres psql -c "CREATE ROLE lifelog WITH LOGIN SUPERUSER CREATEDB CREATEROLE INHERIT NOREPLICATION CONNECTION LIMIT -1 PASSWORD 'xxxxxxx'"; +sudo -u postgres psql -c "CREATE DATABASE lifelog;" ## Start stop Postgres SQL sudo service postgresql start -- 2.34.1