我正在使用C# Visual Studio 2022/.NET6。当我尝试使用容器IP地址172.17.0.2在Docker容器上连接PostgreSQL时，出现异常：

"Host=172.17.0.2:5432;Database=postgres;Username=postgres;Password=xxxxx"

字符串
但是当我使用`localhost '连接时，连接成功：

"Host=localhost:5432;Database=postgres;Username=postgres;Password=xxxxx"

型

• 如何将PostgreSQL安装为Docker容器 *

Step 1 - Install Postgres

docker pull postgres
docker run --name gb-postgres -p 5432:5432 -e POSTGRES_PASSWORD=xxxxxx -d postgres

Step 2 - Once Postgres is installed you need to find out your instance IP address

Run
docker ps

copy the {id  of the container} of the container and run

docker inspect {id  of the container}

copy the IPAddress of the container

Step 3 - Configure API

Use IP address in your Program.cs

型

• 异常 *

Npgsql.NpgsqlException (0x80004005): Failed to connect to 172.17.0.3:5432
 ---> System.TimeoutException: Timeout during connection attempt
   at Npgsql.Internal.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
   at Npgsql.Internal.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
   at Npgsql.Internal.NpgsqlConnector.RawOpen(SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken, Boolean isFirstAttempt)
   at Npgsql.Internal.NpgsqlConnector.<Open>g__OpenCore|203_1(NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken, Boolean isFirstAttempt)
   at Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.PoolingDataSource.OpenNewConnector(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.PoolingDataSource.<Get>g__RentAsync|28_0(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlConnection.<Open>g__OpenAsync|45_0(Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlConnection.Open()
   at Program.Main(String[] args) in D:\data\code\Dust-IO\388013gb3\cloud\API\GB3API\ConsoleApp1\Program.cs:line 14

型

• C#程序 *

using System;
using Npgsql;

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "Host=172.17.0.2;Database=GB3;Username=postgres;Password=xxxxx";

        using (var connection = new NpgsqlConnection(connectionString))
        {
            try
            {
                connection.Open();
                Console.WriteLine("Connected to PostgreSQL database.");

                // Perform database operations here

                connection.Close();
                Console.WriteLine("Connection closed.");
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
            }
        }

        Console.ReadLine();
    }
}

型
甚至当我尝试使用Visual Studio 2022扩展Npgsql PostgreSQL Integration连接时，我也会收到错误Exception while connecting。当我尝试使用VS Code扩展名PostgreSQL by Chris Kolkman连接时，我得到一个连接ETIMEDOUT 172.17.0.2:5432的错误。

• docker检查 *

"Networks": {
                "bridge": {
                    "IPAMConfig": null,
                    "Links": null,
                    "Aliases": null,
                    "NetworkID": "d9371cf11864c75a9c35d03ce24bf90bb78af8f44b43e6336b0630a6d79d9503",
                    "EndpointID": "b235ae6eb713404f9fbbcd35453acb6e9dcb213ad6d51fa8809272912a569e15",
                    "Gateway": "172.17.0.1",
                    "IPAddress": "172.17.0.3",
                    "IPPrefixLen": 16,
                    "IPv6Gateway": "",
                    "GlobalIPv6Address": "",
                    "GlobalIPv6PrefixLen": 0,
                    "MacAddress": "02:42:ac:11:00:03",
                    "DriverOpts": null
                }

型