The easiest way to backup PostgreSQL database on Docker
<pre><code class="language-sh"> docker run --rm --network web \
 -v $PWD/backup:/backup/ \
 -e &quot;DB_HOST=dbhost&quot; \
 -e &quot;DB_USERNAME=username&quot; \
 -e &quot;DB_PASSWORD=password&quot; \
 jkaninda/pg-bkup backup -d database_name --cron-expression @midnight

</code></pre>
<a href="https://github.com/jkaninda/pg-bkup" target="_blank" rel="noopener nofollow">https://github.com/jkaninda/pg-bkup</a>
<ul>
<li><a href="https://github.com/jkaninda/pg-bkup" target="_blank" rel="noopener nofollow">Github</a></li>
<li><a href="https://jkaninda.github.io/pg-bkup/" target="_blank" rel="noopener nofollow">Doc</a></li>
</ul>

Sharing the daily journey in DevOps—tackling challenges, resolving issues, implementing automation, optimizing costs, and more. Join us as we navigate the dynamic world of DevOps, offering insights, tips, and real-world experiences to empower and ins

DevOps Life

Learn how to easily backup a PostgreSQL database using Docker with the `jkaninda/pg-bkup` tool. This solution supports saving backups to local storage, AWS S3, FTP, and SSH remote storage. Key parameters include setting the database host, username, password, and scheduling the backup with a cron expression.

Docker backing up PosgreSQL dabatase to Local, AWS S3, FTP and SSH remote storage