gs_ctl build修复时，FATAL: Forbid remote connection with initial user ？
Hi 备机同步失败，尝试用gs_ctl build修复时，报下面错误： 我一直用的是初始化数据库的超级用户postgres，配主备没问题，这里 " 不能用 initial user " 但是在哪里指定用什么user？能用啥user呢？文档里找不到详细的说明。 [postgres@pg_155 hadb-opengauss]$ gs_ctl build -D _pg_root -b incremental [2022-04-02 16:19:26.630][9988][][gs_ctl]: gs_ctl incremental build ,datadir is /mnt/disk01/hadb-opengauss/_pg_root waiting for server to shut down......... done server stopped [2022-04-02 16:19:32.677][9988][][gs_ctl]: fopen build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.677][9988][][gs_ctl]: fprintf build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.678][9988][][gs_ctl]: fsync build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.689][9988][][gs_rewind]: set gaussdb state file when rewind:db state(BUILDING_STATE), server mode(STANDBY_MODE), build mode(INC_BUILD). [2022-04-02 16:19:32.704][9988][][gs_rewind]: could not connect to server host=172.32.148.156 port=31002 dbname=postgres application_name=gs_rewind connect_timeout=5 rw_timeout=600: FATAL: Forbid remote connection with initial user. 谢谢 新大陆软件 秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn
检查下pg_hba.conf里面配置，postgres用户是否是trust ------------------ 原始邮件 ------------------ 发件人: "qinhao@newland.com.cn" <qinhao@newland.com.cn>; 发送时间: 2022年4月2日(星期六) 下午4:40 收件人: "community"<community@opengauss.org>; 主题: [Community] gs_ctl build修复时，FATAL: Forbid remote connection with initial user ？ Hi 备机同步失败，尝试用gs_ctl build修复时，报下面错误： 我一直用的是初始化数据库的超级用户postgres，配主备没问题，这里 " 不能用 initial user " 但是在哪里指定用什么user？能用啥user呢？文档里找不到详细的说明。 [postgres@pg_155 hadb-opengauss]$ gs_ctl build -D _pg_root -b incremental [2022-04-02 16:19:26.630][9988][][gs_ctl]: gs_ctl incremental build ,datadir is /mnt/disk01/hadb-opengauss/_pg_root waiting for server to shut down......... done server stopped [2022-04-02 16:19:32.677][9988][][gs_ctl]: fopen build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.677][9988][][gs_ctl]: fprintf build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.678][9988][][gs_ctl]: fsync build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.689][9988][][gs_rewind]: set gaussdb state file when rewind:db state(BUILDING_STATE), server mode(STANDBY_MODE), build mode(INC_BUILD). [2022-04-02 16:19:32.704][9988][][gs_rewind]: could not connect to server host=172.32.148.156 port=31002 dbname=postgres application_name=gs_rewind connect_timeout=5 rw_timeout=600: FATAL: Forbid remote connection with initial user. 谢谢 新大陆软件 秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn _______________________________________________ Community mailing list -- community@opengauss.org To unsubscribe send an email to community-leave@opengauss.org
postgres用户改为trust，还是一样的报错，问题关键是提示“ FATAL: Forbid remote connection with initial user.”， 而我确实在用initial user，就是postgres，因为在配主备时-b full是没问题的，主备也能正常运行。 -b incremental时，就是调用pg_rewind，但是pg_rewind有个--source-server参数指定连接主库的rewind用户，但是gs_ctl build没有提供这么一 搞参数，文档里没有。 新大陆软件 秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn 发件人： zhang_xb 发送时间： 2022-04-02 17:06 收件人： qinhao@newland.com.cn; community 主题： 回复： [Community] gs_ctl build修复时，FATAL: Forbid remote connection with initial user ？ 检查下pg_hba.conf里面配置，postgres用户是否是trust ------------------ 原始邮件 ------------------ 发件人: "qinhao@newland.com.cn" <qinhao@newland.com.cn>; 发送时间: 2022年4月2日(星期六) 下午4:40 收件人: "community"<community@opengauss.org>; 主题: [Community] gs_ctl build修复时，FATAL: Forbid remote connection with initial user ？ Hi 备机同步失败，尝试用gs_ctl build修复时，报下面错误： 我一直用的是初始化数据库的超级用户postgres，配主备没问题，这里 " 不能用 initial user " 但是在哪里指定用什么user？能用啥user呢？文档里找不到详细的说明。 [postgres@pg_155 hadb-opengauss]$ gs_ctl build -D _pg_root -b incremental [2022-04-02 16:19:26.630][9988][][gs_ctl]: gs_ctl incremental build ,datadir is /mnt/disk01/hadb-opengauss/_pg_root waiting for server to shut down......... done server stopped [2022-04-02 16:19:32.677][9988][][gs_ctl]: fopen build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.677][9988][][gs_ctl]: fprintf build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.678][9988][][gs_ctl]: fsync build pid file "/mnt/disk01/hadb-opengauss/_pg_root/gs_build.pid" success [2022-04-02 16:19:32.689][9988][][gs_rewind]: set gaussdb state file when rewind:db state(BUILDING_STATE), server mode(STANDBY_MODE), build mode(INC_BUILD). [2022-04-02 16:19:32.704][9988][][gs_rewind]: could not connect to server host=172.32.148.156 port=31002 dbname=postgres application_name=gs_rewind connect_timeout=5 rw_timeout=600: FATAL: Forbid remote connection with initial user. 谢谢 新大陆软件 秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn _______________________________________________ Community mailing list -- community@opengauss.org To unsubscribe send an email to community-leave@opengauss.org
participants (2)
-
qinhao＠newland.com.cn -
zhang_xb