2.4.3 使用postgresql 14数据库，新增配置报 org.postgresql.util.PSQLException: 错误: 函数 now(integer) 不存在

[liuzhiteng]

No description provided.

[wangmaogang]

我也遇到了

[wangmaogang]

已解决

[hucongwei]

遇到同样的问题，没看到解决方案，考虑降级到2.2版本的nacos

./config-fatal.log:2024-12-13 08:28:33,961 ERROR [db-error] try to update or add config failed, PreparedStatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: function now(integer) does not exist
./config-fatal.log:2024-12-13 08:35:47,829 ERROR [db-error] try to update or add config failed, PreparedStatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: function now(integer) does not exist
./config-server.log:2024-12-13 00:04:02,832 ERROR An error occurred while executing method [removeConfigHistory].
./config-server.log:org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM his_config_info WHERE gmt_modified < ? LIMIT ?]; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "LIMIT"
./config-server.log:Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "LIMIT"