Files
Sankofa/api/setup-db-commands.txt

20 lines
520 B
Plaintext
Raw Permalink Normal View History

# Run these commands to set up the database:
# Option 1: If you have sudo access
sudo -u postgres psql << EOSQL
CREATE DATABASE sankofa;
ALTER USER postgres PASSWORD 'dev_sankofa_2024_secure';
\q
EOSQL
# Option 2: If you can connect as postgres user directly
psql -U postgres << EOSQL
CREATE DATABASE sankofa;
ALTER USER postgres PASSWORD 'dev_sankofa_2024_secure';
\q
EOSQL
# Option 3: Using createdb command
createdb -U postgres sankofa
psql -U postgres -c "ALTER USER postgres PASSWORD 'dev_sankofa_2024_secure';"