elestio/postgres

https://img.shields.io/static/v1.svg?logo=***&color=f78A38&labelColor=083468&logoColor=ffffff&style=for-the-badge&label=***&message=community]([***] "Get instant assistance and engage in live discussions with both the community and team through our chat feature.") https://img.shields.io/static/v1.svg?logo=github&color=f78A38&labelColor=083468&logoColor=ffffff&style=for-the-badge&label=github&message=open%20source](https://github.com/elestio-examples "Access the source code for all our repositories by viewing them.") https://img.shields.io/static/v1.svg?color=f78A38&labelColor=083468&logoColor=ffffff&style=for-the-badge&label=elest.io&message=Blog](https://blog.elest.io "Latest news about elestio, open source software, and DevOps techniques.")

Postgres, verified and packaged by Elestio

https://github.com/postgres/postgres is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This distribution also contains C language bindings.

Deploy a https://elest.io/open-source/postgresql on https://elest.io/ if you want automated backups, reverse proxy with SSL termination, firewall, automated OS & Software updates, and a team of Linux experts and open source enthusiasts to ensure your services are always safe, and functional.

Why use Elestio images?

• Elestio stays in sync with updates from the original source and quickly releases new versions of this image through our automated processes.
• Elestio images provide timely access to the most recent bug fixes and features.
• Our team performs quality control checks to ensure the products we release meet our high standards.

Usage

Docker-compose

Here are some example snippets to help you get started creating a container.

version: '3.4'
services:
    postgres:
    image: elestio/postgres:${SOFTWARE_VERSION_TAG}
    restart: always
    environment:
        POSTGRES_DB: postgres
        POSTGRES_USER: postgres
        POSTGRES_PASSWORD: ${SOFTWARE_PASSWORD}
        PGDATA: /var/lib/postgresql/data
    volumes:
        - ./data:/var/lib/postgresql/data
    ports:
        - "172.17.0.1:5432:5432"

Environment variables

Maintenance

Logging

The Elestio Postgres Docker image sends the container logs to stdout. To view the logs, you can use the following command:

docker-compose logs -f

To stop the stack you can use the following command:

docker-compose down

Backup and Restore with Docker Compose

To make backup and restore operations easier, we are using folder volume mounts. You can simply stop your stack with docker-compose down, then backup all the files and subfolders in the folder near the docker-compose.yml file.

Creating a ZIP Archive For example, if you want to create a ZIP archive, navigate to the folder where you have your docker-compose.yml file and use this command:

zip -r myarchive.zip .

Restoring from ZIP Archive To restore from a ZIP archive, unzip the archive into the original folder using the following command:

unzip myarchive.zip -d /path/to/original/folder

Starting Your Stack Once your backup is complete, you can start your stack again with the following command:

docker-compose up -d

That's it! With these simple steps, you can easily backup and restore your data volumes using Docker Compose.

Links

• https://github.com/postgres/postgres

• https://www.postgresql.org/docs/

• https://github.com/elestio-examples/postgres