Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for postgresql cluster #676

Open
NgariNdungu opened this issue Jun 22, 2023 · 0 comments
Open

Support for postgresql cluster #676

NgariNdungu opened this issue Jun 22, 2023 · 0 comments

Comments

@NgariNdungu
Copy link

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant