个人中心
gpt4 book ai didi

unable to connect to postgres from podman(无法从Podman连接到Postgres)

转载 作者：bug小助手 更新时间：2023-10-25 17:45:53 30 4
gpt4 key购买 nike



I am trying to connect to my postgres instance which is running at port 5001 but the connection code is returning the error: [error] failed to initialize database, got error failed to connect to host=localhost user=admin database=contactsdb: failed to receive message (unexpected EOF)

我试图连接到我的postgres实例，该实例在端口5001运行，但连接代码返回错误：[错误]无法初始化数据库，得到错误无法连接到主机=localhost用户=admin数据库=contactsdb：无法接收消息（意外错误）


Podman script

波德曼脚本



podman run --name mypostgres -p 50001:5001 -e POSTGRES_DB=contactsdb -e POSTGRES_USER=admin -e POSTGRES_PASSWORD=admin123 -d postgres



Here's my connection code

这是我的转接码


    dsn:="host=localhost user=admin password=admin123 dbname=contactsdb port=50001"     
    db, err := gorm.Open(postgres.Open(dsn), &gorm.Config{})    
    if err!=nil{
        fmt.Println("Could not Connect")    
    } else{
        fmt.Println("Successfully connected",db)
    }

Here's my postgres container:

这是我的Postgres容器：


CONTAINER ID  IMAGE                              COMMAND               CREATED            STATUS            PORTS                    NAMES
a238196fb656  docker.io/library/mysql:latest     mysqld                8 hours ago        Up 8 hours        0.0.0.0:33406->3306/tcp  mysq2
4ee241546da5  docker.io/library/adminer:latest   php -S [::]:8080 ...  8 hours ago        Up 8 hours        0.0.0.0:48088->8080/tcp  adminui
e7bee47ab8ac  docker.io/library/postgres:latest  postgres              About an hour ago  Up About an hour  0.0.0.0:50001->5001/tcp  mypostgres

更多回答
优秀答案推荐

You need to expose the container to the host’s network by adding --network host to your podman run command.

您需要通过将--Network host添加到您的podman run命令来向主机的网络公开容器。


更多回答

which port should i connect to for my connection string because it's not showing the port in the podman inspect

我应该为我的连接字符串连接到哪个端口，因为它没有在Podman检查中显示端口

30 4 0
文章推荐： How to resolve 'Android SDK license file not found' error in UE 5.1 and UE 5.2 despite agreeing to license in Android project settings in the editor?(如何解决在UE 5.1和UE 5.2中，尽管在编辑器中的Android项目设置中同意许可，但仍存在‘Android SDK许可文件找不到’的错误？)
文章推荐： useState: setState behaving weirdly in StrictMode(UseState：setState在StrictMode中行为异常)
文章推荐： Interact with an exe file which is converted from py file(与从py文件转换而来的exe文件交互)
文章推荐： Animate view alongside NavigationView transition(沿导航设置视图动画视图过渡)
bug小助手
个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章
滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com