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