You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have setup the sql pump pointed to a postgresql cluster which works well until there is a database fail-over.
The pump seems to retain the old connection resulting in error; ERROR: cannot execute INSERT in a read-only transaction (SQLSTATE 25006)
The connection_string am using is; 'host=tyk-postgres-cluster.tyk.svc.cluster.local port=5432 user=tyk_analytics_owner_user dbname=tyk_analytics password=$(DB_OWNER_PASSWORD)'
Where the host points to the cluster service for the master nodes.
Restarting the pump usually fixes the issue.
Does tyk-pump support pushing analytics to a postgresql cluster?
The text was updated successfully, but these errors were encountered:
I have setup the sql pump pointed to a postgresql cluster which works well until there is a database fail-over.
The pump seems to retain the old connection resulting in error;
ERROR: cannot execute INSERT in a read-only transaction (SQLSTATE 25006)
The connection_string am using is;
'host=tyk-postgres-cluster.tyk.svc.cluster.local port=5432 user=tyk_analytics_owner_user dbname=tyk_analytics password=$(DB_OWNER_PASSWORD)'
Where the host points to the cluster service for the master nodes.
Restarting the pump usually fixes the issue.
Does tyk-pump support pushing analytics to a postgresql cluster?
The text was updated successfully, but these errors were encountered: