Skip to content

Postgresql guide#24068

Merged
dvdksn merged 36 commits intodocker:mainfrom
igor-alexandrov:postgresql-guide
Mar 25, 2026
Merged

Postgresql guide#24068
dvdksn merged 36 commits intodocker:mainfrom
igor-alexandrov:postgresql-guide

Conversation

@igor-alexandrov
Copy link
Copy Markdown
Contributor

@igor-alexandrov igor-alexandrov commented Feb 3, 2026

Description

  • Add comprehensive PostgreSQL containerization guide with 4 modules covering setup, configuration, networking, and ecosystem tools
  • Include practical Docker and Docker Compose examples for each topic
  • Cover data persistence strategies (named volumes, bind mounts), initialization scripts, performance tuning, and connection pooling

This PR introduces a new PostgreSQL-specific guide to help users containerize PostgreSQL databases using Docker. The guide is structured into four progressive modules:

  1. Immediate Setup & Data Persistence - Covers running PostgreSQL containers with proper data persistence using named volumes, bind mounts, and Docker Compose configurations.

  2. Advanced Configuration and Initialization - Explains initialization scripts (/docker-entrypoint-initdb.d/), performance tuning parameters (memory settings, connection limits, I/O
    configuration), and timezone/locale settings.

  3. Networking and Connectivity - Details how to configure networking for containerized PostgreSQL deployments.

  4. Companions for PostgreSQL - Introduces ecosystem tools including pgAdmin 4 for visual management, PgBouncer and Pgpool-II for connection pooling, and pgbench for performance testing.

Examples include tabs showing both Docker Hardened Images (DHI) and Docker Official Images (DOI) variants where applicable.

The guide is prepared by @igor-alexandrov, @edithturn, and @Expeto.

Reviews

  • Technical review
  • Editorial review
  • Product review

@netlify
Copy link
Copy Markdown

netlify Bot commented Feb 3, 2026

Deploy Preview for docsdocker ready!

Name Link
🔨 Latest commit 7679b5e
🔍 Latest deploy log https://app.netlify.com/projects/docsdocker/deploys/69b83918d31235000882cbe1
😎 Deploy Preview https://deploy-preview-24068--docsdocker.netlify.app
📱 Preview on mobile
Toggle QR Code...

QR Code

Use your smartphone camera to open QR code link.

To edit notification comments on pull requests, go to your Netlify project configuration.

@igor-alexandrov igor-alexandrov marked this pull request as draft February 3, 2026 22:50
@igor-alexandrov igor-alexandrov marked this pull request as ready for review February 13, 2026 19:59
Copy link
Copy Markdown
Contributor

@tippexs tippexs left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Just a small remark. Other then that, Great Work LGTM

Comment thread content/guides/postgresql/companions-for-postgresql.md Outdated
@craig-osterhout craig-osterhout requested a review from a team February 26, 2026 17:03
@craig-osterhout craig-osterhout added the status/review Pull requests that are ready for review label Feb 26, 2026
Copy link
Copy Markdown
Contributor

@craig-osterhout craig-osterhout left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks @igor-alexandrov and all.
It looks great!
I left mostly style nits, not any technical blockers.

Comment thread content/guides/postgresql/_index.md Outdated
Comment thread content/guides/postgresql/_index.md Outdated
Comment thread content/guides/postgresql/_index.md Outdated
Comment thread content/guides/postgresql/_index.md Outdated
Comment thread content/guides/postgresql/_index.md Outdated
Comment thread content/guides/postgresql/companions-for-postgresql.md Outdated
Comment thread content/guides/postgresql/companions-for-postgresql.md Outdated
Comment thread content/guides/postgresql/companions-for-postgresql.md Outdated
Comment thread content/guides/postgresql/companions-for-postgresql.md Outdated
Comment thread content/guides/postgresql/companions-for-postgresql.md Outdated
Comment thread content/guides/postgresql/companions-for-postgresql.md Outdated
Comment thread content/guides/postgresql/advanced-configuration-and-initialization.md Outdated
Comment thread content/guides/postgresql/advanced-configuration-and-initialization.md Outdated
Comment thread content/guides/postgresql/immediate-setup-and-data-persistence.md Outdated
edithturn and others added 3 commits March 2, 2026 11:20
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
edithturn and others added 10 commits March 2, 2026 11:21
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: Craig Osterhout <craig.osterhout@docker.com>
Co-authored-by: David Karlsson <35727626+dvdksn@users.noreply.github.com>
…ation.md

Co-authored-by: David Karlsson <35727626+dvdksn@users.noreply.github.com>
…ation.md

Co-authored-by: David Karlsson <35727626+dvdksn@users.noreply.github.com>
@igor-alexandrov
Copy link
Copy Markdown
Contributor Author

@craig-osterhout @dvdksn we resolved all your comments. Thank you for finding a time to review this.

@dvdksn
Copy link
Copy Markdown
Contributor

dvdksn commented Mar 3, 2026

/review

Copy link
Copy Markdown
Contributor

@docker-agent docker-agent Bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Review Summary

This comprehensive PostgreSQL containerization guide is well-structured and provides clear, practical examples for users. The content accurately explains Docker concepts, PostgreSQL configuration, and networking patterns.

The guide successfully covers:

  • Data persistence with named volumes and bind mounts
  • Initialization scripts and performance tuning
  • Container networking for both internal and external access
  • Ecosystem tools like pgAdmin and PgBouncer

All commands are correct, examples are functional, and the progressive structure (from quick start to advanced topics) makes this approachable for users at different skill levels.

No blocking issues found. Great work! 🎉

@igor-alexandrov
Copy link
Copy Markdown
Contributor Author

@dvdksn @craig-osterhout ping ping.

@dvdksn
Copy link
Copy Markdown
Contributor

dvdksn commented Mar 13, 2026

@igor-alexandrov looks like some of @craig-osterhout 's comments are still unresolved, eg https://github.com/docker/docs/pull/24068/changes#r2861666681

@igor-alexandrov
Copy link
Copy Markdown
Contributor Author

@dvdksn sorry for this. The new GitHub UI is getting worse and worse. I resolved all comments.

Copy link
Copy Markdown
Contributor

@dvdksn dvdksn left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@dvdksn dvdksn merged commit 955c955 into docker:main Mar 25, 2026
15 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

area/guides status/review Pull requests that are ready for review

Projects

None yet

Development

Successfully merging this pull request may close these issues.

5 participants