expose postgresql so that it can be accessed outside of Docker

[Pomax]

This is especially important for database issues relating to real data, such as deleting user accounts from the prod/staging instances.

[cadecairos]

The root of the problem here is that we're defaulting to using SQLite.

We need to update a few things. Firstly, we need to update docker-compose.yml:

In the postgres service, update ports to be: `"5432:5431" (changes the port exposed on the host in case it's already running a postgres DB). In the same service, add:

environment:
  - POSTGRES_USER=foundationsite
  - POSTGRES_PASSWORD=devmode
  - POSTGRES_DB=foundationsite

This will, upon DB creation, add foundationsite as a super user, set their password to devmode and create a default database named foundationsite. This will allow us to connect to the database without needing to use trust authentication, which is the default.

We'll need to update the default connection string in env.default to be postgres://foundationsite:devmode@localhost:5431/foundationsite. There might be some other places we need to set this, but I don't think we need to do anything to support this change on our CI, since it's not using Docker.

[cadecairos]

helpful reference: https://hub.docker.com/_/postgres

Scroll down to "Environment Variables"

[Pomax]

turns out the ports are host:docker, rather than docker:host. Things now work except that postgres does not know the 'foundationsite' role, so I'm simply going to make this postgres for db, user, and database and see if that works.

[Pomax]

PR filed, it changes tasks.py a little, checking the docker-compose.yml for creds, and if found, templates those in:

    with open(env_file, 'r') as f:
        env_vars = f.read()

    # We need to strip the quotes because Docker-compose considers them as part of the env value.
    env_vars = env_vars.replace('"', '')

    # We also need to make sure to use the correct db values based on our docker settings.
    username = password = dbname = 'postgres'
    with open('docker-compose.yml', 'r') as d:
        docker_compose = d.read()
        username = re.search('POSTGRES_USER=(.*)', docker_compose).group(1) or username
        password = re.search('POSTGRES_PASSWORD=(.*)', docker_compose).group(1) or password
        dbname = re.search('POSTGRES_DB=(.*)', docker_compose).group(1) or dbname

    # Update the DATABASE_URL env
    new_db_url = f"DATABASE_URL=postgresql://{username}:{password}@postgres:5432/{dbname}"
    old_db_url = re.search('DATABASE_URL=.*', env_vars)
    env_vars = env_vars.replace(old_db_url.group(0), new_db_url)