bash setup.sh

# PostgreSQL
psql -h localhost -U postgres

# Redis
redis-cli -h localhost

# From your local machine - PostgreSQL
ssh -L 5432:localhost:5432 user@your-server

# From your local machine - Redis
ssh -L 6379:localhost:6379 user@your-server

# Then connect from your local machine
psql -h localhost -U postgres
redis-cli -h localhost

# View PostgreSQL password
grep POSTGRES_PASSWORD ~/.db_passwords.env

# View Redis password
grep REDIS_PASSWORD ~/.db_passwords.env

# Or view the entire file
cat ~/.db_passwords.env

# Using psql
psql -h localhost -U postgres
# Enter password when prompted (retrieve from ~/.db_passwords.env)

# Or using Docker exec (no password needed)
docker exec -it postgres psql -U postgres

# Or install client
sudo apt install postgresql-client
psql -h localhost -U postgres

source ~/.db_passwords.env
psql -h localhost -U postgres -W
# Enter password: $POSTGRES_PASSWORD

# Using redis-cli
redis-cli -h localhost
# Enter password: AUTH <password> (retrieve from ~/.db_passwords.env)

# Or using Docker exec (no password needed)
docker exec -it redis redis-cli

# Or install client
sudo apt install redis-tools
redis-cli -h localhost

source ~/.db_passwords.env
redis-cli -h localhost -a "$REDIS_PASSWORD"

# From environment file
source ~/.db_passwords.env
export PGPASSWORD="$POSTGRES_PASSWORD"
psql -h localhost -U postgres -d postgres

# From environment file
source ~/.db_passwords.env
redis-cli -h localhost -a "$REDIS_PASSWORD"

## Manage containers

```bash
docker ps                    # See running containers
docker stop postgres redis   # Stop databases
docker start postgres redis  # Start databases
docker logs postgres         # View logs
docker logs redis            # View Redis logs
docker exec -it postgres bash # Get shell in container
docker exec -it redis redis-cli # Redis CLI