Production Notes - garageScript/databases GitHub Wiki
Intro
Information about production app servers
General notes
When generating passwords, use a tool like passwordsgenerator.net to generate strong passwords!
PostgreSQL setup
- Create user with ability to create databases and other users:
create user learndb with password 'wQhw6XHxacds9sX4' CREATEDB CREATEROLE;
- Create a database with the user as owner
create database learndb owner learndb;
CI Job
We currently use a server, songz.dev (Documents/actions-runner
), to run our CI jobs. We followed the setup instructions for self hosted runners
- To configure the runner's
.env
variables, modify the.env
file in the downloaded folder - Run the process in the background
./svc.sh
- start the background process.