April 2022 - Community - mailweb.opengauss.org

gs_ctl build修复时，FATAL: Forbid remote connection with initial user ？
by qinhao＠newland.com.cn 06 Apr '22

06 Apr '22

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

2 2

openGauss安装问题
by 林敏之 03 Apr '22

03 Apr '22

我是一个个人开发者正在打算使用贵公司的openGauss作为数据库进行APP开发目前正在openEuler上安装部署openGauss极简版在这个部署过程中我遇到了问题截图如下目前无法完成部署按照官方给的教程检查结果如下请问这是什么问题？

1 0

关于PTRACK临时文件位置
by Don't mind☭ 02 Apr '22

02 Apr '22

HI      关于ptrack增量备份块功能的说明实在稀少。现在我已经知道pg_cbm_get_changed_block这个函数可以获取数据文件变化块，然后我有几个问题。    1.ptrack会使用位图来记录变化块。根据postgres pro提供的文档，ptrack会产生两个临时文件并且在临时文件中也会记录lsn位置。请问opengauss也会产生这两个临时文件么？这个临时文件的位置在哪，lsn号是否也记录在其中。    2.lsn号是永远有效还是多久会失效。我们需要根据lsn的特性确认我们的备份策略。lsn是存储在库中，wal日志中还是哪里，多久之前的lsn号将无法查询？这将影响到我们的增量备份间隔多久需要重新进行全量备份周玥铖电话：18115127620 e-mail:1224077693@qq.com

1 0

Propose @ailoooong as committer of SIG Infra
by xiangxinyong 02 Apr '22

02 Apr '22

Hi team, I would like to propose @ailoooong as the committer of SIG Infra. @ailoooong joined openGauss community and contributed from July last year. @ailoooong has submitted more the 65 pull requests based on openGauss official website in community. Find more contributions from his gitee account. https://gitee.com/ailoooong Feel free to give your suggestions. Thanks very much. Best Regards, Edison Xiang

1 0