postgresml/pgcat

ERROR pgcat::server: Unknown code: N

Opened this issue · 2 comments

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

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

cmdel commented

I'm seeing the same thing running in Nomad. Have you managed to figure out what the issue was?