How to Connect PgAdmin with Local PostgreSQL When Using Docker: Essential Tips

Описание: Learn how to successfully connect PgAdmin running in Docker to your locally installed PostgreSQL database on Ubuntu with our step-by-step guide.
---
This video is based on the question https://stackoverflow.com/q/78172501/ asked by the user 'marietar' ( https://stackoverflow.com/u/20724834/ ) and on the answer https://stackoverflow.com/a/78172542/ provided by the user 'Kobra' ( https://stackoverflow.com/u/23237053/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, comments, revision history etc. For example, the original title of the Question was: postresql installed locally and use pgadmin with docker ; can't connect to my local database

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Connect PgAdmin with Local PostgreSQL When Using Docker: Essential Tips

If you are venturing into the world of Docker, you might encounter some challenges, especially when trying to connect your PgAdmin running in a Docker container to a PostgreSQL database installed locally on your system. This guide will help you resolve these connectivity issues and get you up and running smoothly.

Understanding the Problem

You have successfully installed PostgreSQL on your Ubuntu machine; however, you are now learning Docker and have installed PgAdmin inside a Docker container. After setting it up, you’re trying to connect PgAdmin to your local PostgreSQL database but receiving connection errors.

Here’s a quick breakdown of your setup:

PostgreSQL is installed directly on your local machine (Ubuntu).

PgAdmin is installed via Docker.

You attempted to connect using the default settings but were met with an error indicating a connection failure.

Solution to Connect PgAdmin with Local PostgreSQL

Fortunately, resolving this issue is straightforward. Here’s how to successfully connect the two:

Step 1: Update Your Host Address

When connecting from a Docker container to services running on the host machine, you typically cannot use localhost. Instead, you should change your connection settings. Here's what you need to do:

For Linux Users

Replace localhost with 172.17.0.1. This is usually the default IP address that Docker uses to connect to the host on Linux.

Connection Details:

Home address: 172.17.0.1

Port: 5432 (default PostgreSQL port)

Maintenance database: postgres

Username: postgres

Password: [Your Password]

For Windows and MacOS Users

Instead of using localhost, you should use host.docker.internal.

Connection Details:

Home address: host.docker.internal

Port: 5432

Maintenance database: postgres

Username: postgres

Password: [Your Password]

Step 2: Verify Docker Network Configuration

In some cases, the default IP address for Docker may not be 172.17.0.1. To find your current Docker bridge IP address, you can run the following command in your terminal:

[[See Video to Reveal this Text or Code Snippet]]

This will display the correct IP address that you'll need to use.

Conclusion

By substituting localhost with the correct IP address or host reference based on your operating system, you can effectively connect PgAdmin in Docker to your locally-installed PostgreSQL database. This will allow you to use PgAdmin seamlessly without moving your PostgreSQL installation into Docker.

If you still face connection issues after these adjustments, ensure your PostgreSQL server is running and listening on the correct port. Additionally, check your firewall settings to ensure there's no blockage on port 5432.

Feel free to ask if you have further questions or if you're facing any other issues with Docker, PgAdmin, or PostgreSQL!