====== Postgres ======

===== Dump database from the command line =====

<code bash>
pg_dump --user=my-user --password my-db
</code>

''pg_dump'' will prompt for a password. If you don't want it to prompt for a password, you need to create a file called ''.pgpass'' with the following format:

<code>
hostname:port:database:username:password
</code>

and then ''chmod'' it to 600:

<code>
chmod 600 ~/.pgpass
</code>

==== Docker example ====

After creating the ''.pgpass'' file on the container home using ''docker exec'' or a volume mount:

<code bash>
docker exec my_db_container pg_dump --user=postgres my-db >> my-db-backup.sql
</code>

===== Run SQL files on docker creation =====

Useful for first time database creations. Using the ''postgres'' docker, run the following config:

<code bash>
docker run --name my-postgres \
  -p 5432:5432 \
  -v my/sql/files/location:/docker-entrypoint-initdb.d \
  -e POSTGRES_DB=app \
  -e POSTGRES_PASSWORD=postgres \
  postgres
</code>

Be sure the ''POSTGRES_DB'', ''POSTGRES_PASSWORD'' and ''POSTGRES_USER'' match the .sql script