Postgres Docker

Build

docker build -t pennassurancesoftware/postgres:latest .

Run

docker stop db; docker rm db;
docker run -d --name=db -p 5432:5432 -e POSTGRES_USER="super" -e POSTGRES_DB="yaas" -e POSTGRES_PASSWORD="postgres" pennassurancesoftware/postgres:latest; docker logs -f db

Inspect

You can run psql command against the running database:

docker run -it --rm --link db:postgres postgres psql -h postgres -U postgres postgres

Connect as the user you created for your databsae:

docker run -it --rm --link db:postgres postgres psql -h postgres -U super yaas

Notes

I used the pynab-docker repository as a reference.

Another reference for setting up Postgres in Docker: postgres-docker

Setup AWS

1. Create a file aws.env with the AWS credentials

AWS_ACCESS_KEY_ID=your_access_key_id
AWS_SECRET_ACCESS_KEY=your_secret_access_key

2. Generate encryption key

jet generate

3. Add aws.env and codeship.aes to .gitignore

aws.env
codeship.aes

3. Encrypt the file

jet encrypt aws.env aws.env.encrypted

4. Test build

jet steps --push