如果当前用户不是pg_trgm的所有者,你需要使用具有足够权限的用户(如超级用户)来执行后续操作。如果你是超级用户或有权限更改扩展所有者的用户,你可以继续下一步。 更改pg_trgm扩展的所有者为当前用户或适当的用户: 如果你需要更改扩展的所有者,可以使用超级用户登录并运行以下命令:sql...
ERROR: must be owner of extension btree_gist ERROR: must be owner of extension pg_trgm 修改postgresql相关配置 修改端口监听地址,默认监控localhost,* 代表all vi /var/opt/gitlab/postgresql/data/postgresql.conf listen_addresses = '*' 最底下添加两行 vi /var/opt/gitlab/postgresql/data/pg_hba.conf...
ERROR: must be owner of extension btree_gist ERROR: must be owner of extension pg_trgm 1. 修改postgresql相关配置 # 修改端口监听地址,默认监控localhost,* 代表all vi /var/opt/gitlab/postgresql/data/postgresql.conf listen_addresses = '*' #最底下添加两行 vi /var/opt/gitlab/postgresql/data/pg...
ERROR: must be owner of extension btree_gist ERROR: must be owner of extension pg_trgm 1. 修改postgresql相关配置 # 修改端口监听地址,默认监控localhost,* 代表all vi /var/opt/gitlab/postgresql/data/postgresql.conf listen_addresses = '*' #最底下添加两行 vi /var/opt/gitlab/postgresql/data/pg...
ERROR: could not open extension control file "/usr/pgsql-11/share/extension/plctl.control": No such file or directory AIBE01PR=# If that is cut/and/pasted, then it is crystal clear that it won't work because there's a typo.