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

ERROR pgcat::server: Unknown code: N #723

Open
zsheep5 opened this issue Apr 16, 2024 · 1 comment
Open

ERROR pgcat::server: Unknown code: N #723

zsheep5 opened this issue Apr 16, 2024 · 1 comment

Comments

@zsheep5
Copy link

zsheep5 commented Apr 16, 2024

pgCat will not start with replica server configured returns ERROR pgcat::server: Unknown code: N when connecting to the replica server, Removing the replica in the server list pgcat will start

Primary PostgreSQL version 15 running in LXC container, OS Ubuntu Focal
Replica PostgreSQL version 15 running in LXC container, OS Ubuntu Focal

Streaming replication is setup and working
validated via psql that bi-directional network connection is working
validated the TLS is working and PostgreSQL will accept the connection

PgCat installed in the primary's LXC container
PgCat running versions v1.1.1

Primarily interest is pooling and load balance feature of pgCat not sure if the modified configuration file is correct

attached is the configuration file
config.txt

@zsheep5
Copy link
Author

zsheep5 commented Apr 17, 2024

I tried a different configuration that I snagged from here
https://dev.to/yugabyte/pgcat-a-postgresql-pooler-3a24

PgCat no longer shuts down with errors but remains running however reports the same errors
pg_cat
pgcat_2.txt

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