# 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';"