Validator Notes - Node Deployment Tutorials

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?