DEV Community

NamLuu
NamLuu

Posted on

I have problem with cluster postgre after I change node IP

data from node syncstandby is not sync data from leader and error log:

ERROR: Exception when working with leader
Traceback (most recent call last):
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
with get_connection_cursor(connect_timeout=3, options='-c statement_timeout=2000', conn_kwargs) as cur:
File "/usr/lib64/python3.6/contextlib.py", line 81, in enter
return next(self.gen)
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
conn = psycopg.connect(
kwargs)
File "/usr/local/lib/python3.6/site-packages/patroni-3.0.2-py3.6.egg/patroni/psycopg.py", line 42, in connect
ret = connect(*args, **kwargs)
File "/usr/local/lib64/python3.6/site-packages/psycopg2/
init_.py", line 121, in connect
dsn = _ext.make_dsn(dsn, **kwargs)
File "/usr/local/lib64/python3.6/site-packages/psycopg2/extensions.py", line 167, in make_dsn
parse_dsn(dsn)
psycopg2.ProgrammingError: invalid dsn: invalid connection option "target_session_attrs"

please help me, I dont know why It happen

Heroku

Built for developers, by developers.

Whether you're building a simple prototype or a business-critical product, Heroku's fully-managed platform gives you the simplest path to delivering apps quickly — using the tools and languages you already love!

Learn More

Top comments (0)

👋 Kindness is contagious

Explore this insightful post in the vibrant DEV Community. Developers from all walks of life are invited to contribute and elevate our shared know-how.

A simple "thank you" could lift spirits—leave your kudos in the comments!

On DEV, passing on wisdom paves our way and unites us. Enjoyed this piece? A brief note of thanks to the writer goes a long way.

Okay