Merge ~ubuntu-docker-images/ubuntu-docker-images/+git/templates:postgresql into ~ubuntu-docker-images/ubuntu-docker-images/+git/templates:master

[Sergio Durigan Junior]

Postgres data (needed to generate the README file) and the corresponding postgres.md (generated from the data).

[Valentin Viennot (valentinviennot)]

there's a tiny mistake in the run command

review: Needs Fixing

[Sergio Durigan Junior (sergiodj)]

On Saturday, November 21 2020, Valentin Viennot wrote:

> Review: Needs Fixing
>
> there's a tiny mistake in the run command

Thanks, I fixed the mistake and merged the MP.

--
Sergio
GPG key ID: E92F D0B3 6B14 F1F4 D8E0 EB2F 106D A1C8 C3CB BF14

diff --git a/data/postgres.yaml b/data/postgres.yaml
new file mode 100644
index 0000000..621d565
--- /dev/null
+++ b/data/postgres.yaml
@@ -0,0 +1,73 @@
+application: Postgres
+repo: postgres
+description: >
+  PostgreSQL is a powerful, open source object-relational database system. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. Read more on the [PostgreSQL website](https://www.postgresql.org/docs/).
+version: "12.4"
+base: Ubuntu 20.04 LTS
+architectures:
+  - amd64
+  - arm64
+  - s390x
+docker:
+  parameters:
+    - -p 30432:5432
+    - -e POSTGRES_PASSWORD=My:s3Cr3t/
+  access: Access your Redis server at `localhost:30432`.
+parameters:
+  - type: -e
+    value: TZ=UTC
+    description: Timezone.
+  - type: -e
+    value: POSTGRES_PASSWORD=secret
+    description: Set the password for the superuser which is `postgres` by default. Bear in mind that to connect to the database in the same host the password is not needed but to access it via an external host (for instance another container) the password is needed. This option is **mandatory** and **must not be empty**.
+  - type: -e
+    value: POSTGRES_USER=john
+    description: Create a new user with superuser privileges. This is used in conjunction with `POSTGRES_PASSWORD`.
+  - type: -e
+    value: POSTGRES_DB=db_test
+    description: Set the name of the default database.
+  - type: -e
+    value: POSTGRES_INITDB_ARGS="--data-checksums"
+    description: Pass arguments to the `postgres initdb` call.
+  - type: -e
+    value: POSTGRES_INITDB_WALDIR=/path/to/location
+    description: Set the location of the Postgres transaction log. By default it is stored in a subdirectory of the main Postgres data folder (`PGDATA`).
+  - type: -e
+    value: POSTGRES_HOST_AUTH_METHOD=trust
+    description: "Set the `auth-method` for `host` connections for `all` databases, `all` users, and `all` addresses. The following will be added to the `pg_hba.conf` if this option is passed: `host all all all $POSTGRES_HOST_AUTH_METHOD`."
+  - type: -e
+    value: PGDATA=/path/to/location
+    description: Set the location of the database files. The default is `/var/lib/postgresql/data`.
+  - type: -p
+    value: 30432:5432
+    description: Expose Postgres on `localhost:30432`.
+  - type: -v
+    value: /path/to/postgresql.conf:/etc/postgresql/postgresql.conf
+    description: Local [configuration file](https://www.postgresql.org/docs/12/index.html) `postgresql.conf` (try [this example](https://git.launchpad.net/~canonical-server/ubuntu-docker-images/+git/postgresql/plain/examples/config/postgresql.conf)).
+  - type: -v
+    value: /path/to/persisted/data:/var/lib/postgresql/data
+    description: Persist data instead of initializing a new database every time you launch a new container.
+debug:
+  extraparagraph: |
+    #### Initialization Scripts
+
+    One can also add initialization scripts to their containers. This includes `*.sql`, `.sql.gz`, and `*.sh` scripts, and you just need to put them inside the  `/docker-entrypoint-initdb.d` directory inside the container. After Postgres initialization is done and the default database and user are created, the scripts are executed in the following order:
+
+    * Run any `*.sql` files in alphabetically order. It will be executed with `POSTGRES_USER`.
+    * Run any executable `*.sh` scripts in alphabetically order.
+    * Source any non-executable `*.sh` scripts in alphabetically order.
+
+    All of this is done before the Postgres service is started. Keep in mind if your `PGDATA` directory is not empty (contains pre-existing database) they will be left untouched.
+  network:
+    client: psql
+    args: -h postgres-container -U postgres
+    helper: The password will be asked and you can enter `My:s3Cr3t/`. Now, you are logged in and can enjoy your new instance.
+microk8s:
+  configmap:
+    files:
+      - key: main-config
+        name: postgresql.conf
+        link: https://git.launchpad.net/~canonical-server/ubuntu-docker-images/+git/postgresql/plain/examples/config/postgresql.conf
+  deploy:
+    link: https://git.launchpad.net/~canonical-server/ubuntu-docker-images/+git/postgresql/plain/examples/postgres-deployment.yml
+    access: You will now be able to connect to the Postgres server on `localhost:30306`.
diff --git a/out/postgres.md b/out/postgres.md
new file mode 100644
index 0000000..1c2a674
--- /dev/null
+++ b/out/postgres.md
@@ -0,0 +1,106 @@
+# Postgres | Ubuntu
+
+
+## About Postgres
+
+PostgreSQL is a powerful, open source object-relational database system. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. Read more on the [PostgreSQL website](https://www.postgresql.org/docs/).
+
+
+## Tags and Architectures
+
+
+| Tag | Currently | Architectures |
+|---|---|---|
+| `12.x`    ![BETA](https://assets.ubuntu.com/v1/e8ac33d1-header-beta-flag.svg) | Postgres 12.4 on Ubuntu 20.04 LTS | `amd64`, `arm64`, `s390x` |
+
+## Usage
+
+Launch this image locally:
+
+```sh
+docker run -d --name postgres-container -e TZ=UTC -p 30432:5432 -e POSTGRES_PASSWORD=My:s3Cr3t/ ubuntu/postgres:12.x
+```
+
+Access your Redis server at `localhost:30432`.
+
+#### Parameters
+
+| Parameter | Description |
+|---|---|
+| `-e TZ=UTC` | Timezone. |
+| `-e POSTGRES_PASSWORD=secret` | Set the password for the superuser which is `postgres` by default. Bear in mind that to connect to the database in the same host the password is not needed but to access it via an external host (for instance another container) the password is needed. This option is **mandatory** and **must not be empty**. |
+| `-e POSTGRES_USER=john` | Create a new user with superuser privileges. This is used in conjunction with `POSTGRES_PASSWORD`. |
+| `-e POSTGRES_DB=db_test` | Set the name of the default database. |
+| `-e POSTGRES_INITDB_ARGS="--data-checksums"` | Pass arguments to the `postgres initdb` call. |
+| `-e POSTGRES_INITDB_WALDIR=/path/to/location` | Set the location of the Postgres transaction log. By default it is stored in a subdirectory of the main Postgres data folder (`PGDATA`). |
+| `-e POSTGRES_HOST_AUTH_METHOD=trust` | Set the `auth-method` for `host` connections for `all` databases, `all` users, and `all` addresses. The following will be added to the `pg_hba.conf` if this option is passed: `host all all all $POSTGRES_HOST_AUTH_METHOD`. |
+| `-e PGDATA=/path/to/location` | Set the location of the database files. The default is `/var/lib/postgresql/data`. |
+| `-p 30432:5432` | Expose Postgres on `localhost:30432`. |
+| `-v /path/to/postgresql.conf:/etc/postgresql/postgresql.conf` | Local [configuration file](https://www.postgresql.org/docs/12/index.html) `postgresql.conf` (try [this example](https://git.launchpad.net/~canonical-server/ubuntu-docker-images/+git/postgresql/plain/examples/config/postgresql.conf)). |
+| `-v /path/to/persisted/data:/var/lib/postgresql/data` | Persist data instead of initializing a new database every time you launch a new container. |
+
+#### Initialization Scripts
+
+One can also add initialization scripts to their containers. This includes `*.sql`, `.sql.gz`, and `*.sh` scripts, and you just need to put them inside the  `/docker-entrypoint-initdb.d` directory inside the container. After Postgres initialization is done and the default database and user are created, the scripts are executed in the following order:
+
+* Run any `*.sql` files in alphabetically order. It will be executed with `POSTGRES_USER`.
+* Run any executable `*.sh` scripts in alphabetically order.
+* Source any non-executable `*.sh` scripts in alphabetically order.
+
+All of this is done before the Postgres service is started. Keep in mind if your `PGDATA` directory is not empty (contains pre-existing database) they will be left untouched.
+
+
+#### Testing/Debugging
+
+To debug the container:
+
+```sh
+$ docker logs -f postgres-container
+```
+
+To get an interactive shell:
+
+```sh
+$ docker exec -it postgres-container /bin/bash
+```
+
+This image also includes the `psql` client for interactive container use:
+
+```sh
+$ docker network create postgres-network
+$ docker network connect postgres-network postgres-container
+$ docker run -it --rm --network postgres-network ubuntu/postgres:12.x psql -h postgres-container -U postgres
+```
+
+The password will be asked and you can enter `My:s3Cr3t/`. Now, you are logged in and can enjoy your new instance.
+
+## Deploy with Kubernetes
+
+
+
+Works with any Kubernetes; if you don't have one, we recommend you [install MicroK8s](https://microk8s.io/) and `microk8s enable dns storage` then alias `kubectl` to `microk8s.kubectl`.
+
+Download
+[postgresql.conf](https://git.launchpad.net/~canonical-server/ubuntu-docker-images/+git/postgresql/plain/examples/config/postgresql.conf), and
+[postgres-deployment.yml](https://git.launchpad.net/~canonical-server/ubuntu-docker-images/+git/postgresql/plain/examples/postgres-deployment.yml). Then:
+
+```sh
+$ kubectl create configmap postgres-config --from-file=main-config=postgresql.conf
+$ kubectl apply -f postgres-deployment.yml
+```
+
+You will now be able to connect to the Postgres server on `localhost:30306`.
+
+## Bugs and feature requests
+
+If you find a bug in our image or want to request a specific feature, please file a bug here:
+
+[https://bugs.launchpad.net/ubuntu-docker-images/+filebug](https://bugs.launchpad.net/ubuntu-docker-images/+filebug)
+
+Please title the bug "`postgres: <reason>`".
+
+Make sure to include the digest of the image you are using, from:
+```sh
+$ docker images --no-trunc --quiet ubuntu/postgres:<tag>
+```
+