-
-
Save buckyroberts/b2be573741650542d523bb4e559270dc to your computer and use it in GitHub Desktop.
Validator Notes | |
before running sudo pip3 install -r requirements/production.txt | |
run this | |
sudo apt-get install libpq-dev -y | |
then run this - | |
sudo apt install postgresql postgresql-contrib -y | |
sudo -u postgres psql | |
CREATE DATABASE thenewboston; | |
CREATE USER deploy WITH PASSWORD ‘password1234’; | |
ALTER ROLE deploy SET client_encoding TO ‘utf8’; | |
ALTER ROLE deploy SET default_transaction_isolation TO ‘read committed’; | |
ALTER ROLE deploy SET timezone TO ‘UTC’; | |
GRANT ALL PRIVILEGES ON DATABASE thenewboston TO deploy; | |
\q |
Forgot the step about adding the CREATE ROLE deploy;
Can you specify where exactly this "CREATE ROLE deploy;" must be added? After what line? For example like this?
Validator Notes
before running sudo pip3 install -r requirements/production.txt
run this
sudo apt-get install libpq-dev -y
then run this -
sudo apt install postgresql postgresql-contrib -y
sudo -u postgres psql
CREATE DATABASE thenewboston;
CREATE USER deploy WITH PASSWORD ‘password1234’;
********************************************* CREATE ROLE deploy;*************************
ALTER ROLE deploy SET client_encoding TO ‘utf8’;
ALTER ROLE deploy SET default_transaction_isolation TO ‘read committed’;
ALTER ROLE deploy SET timezone TO ‘UTC’;
GRANT ALL PRIVILEGES ON DATABASE thenewboston TO deploy;
\q
"
Also for those who run into issues setting utc
ALTER ROLE deploy SET timezone = 'UTC';
If I skipped one of the steps should I restart from the beginning and if so how far back do I go? Should I terminate the instance? How many instances can I make and delete? If I can back up steps how do I do that?
Forgot the step about adding the CREATE ROLE deploy;