The latest articles on DEV Community by NamLuu (@namluucong). https://dev.to/namluucong https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1140494%2Fc3c98962-4fba-4d12-a63f-27c89fdd1df8.png https://dev.to/namluucong en NamLuu Thu, 17 Aug 2023 04:34:57 +0000 https://dev.to/namluucong/i-have-problem-with-cluster-postgre-after-i-change-node-ip-23ap https://dev.to/namluucong/i-have-problem-with-cluster-postgre-after-i-change-node-ip-23ap <p>data from node syncstandby is not sync data from leader and error log: </p> <p>ERROR: Exception when working with leader<br> Traceback (most recent call last):<br> File "/usr/local/lib/python3.6/site-packages/patroni-3.0.2-py3.6.egg/patroni/postgresql/rewind.py", line 69, in check_leader_is_not_in_recovery<br> with get_connection_cursor(connect_timeout=3, options='-c statement_timeout=2000', <strong>conn_kwargs) as cur:<br> File "/usr/lib64/python3.6/contextlib.py", line 81, in <strong>enter</strong><br> return next(self.gen)<br> File "/usr/local/lib/python3.6/site-packages/patroni-3.0.2-py3.6.egg/patroni/postgresql/connection.py", line 43, in get_connection_cursor<br> conn = psycopg.connect(</strong>kwargs)<br> File "/usr/local/lib/python3.6/site-packages/patroni-3.0.2-py3.6.egg/patroni/psycopg.py", line 42, in connect<br> ret = <em>connect(*args, **kwargs)<br> File "/usr/local/lib64/python3.6/site-packages/psycopg2/</em><em>init</em>_.py", line 121, in connect<br> dsn = _ext.make_dsn(dsn, **kwargs)<br> File "/usr/local/lib64/python3.6/site-packages/psycopg2/extensions.py", line 167, in make_dsn<br> parse_dsn(dsn)<br> psycopg2.ProgrammingError: invalid dsn: invalid connection option "target_session_attrs"</p> <p>please help me, I dont know why It happen </p> patroni