After upgrade from Pg11.2 to 17.7 logical replication prevents database instance shutdown

Hello, We have recently upgraded from PostgreSQL 11.2 to PostgreSQL 17.7. We have logical replication between two database instances; no third-party CDC consumers are used. During low traffic on the publisher database, there are no issues, and the publisher instance shutdown is smooth, as expecte

Fwd: restore_command on high-throughput cluster never switches to streaming replication

Hi PostgreSQL community. I debugged an instance where a PostgreSQL standby would not switch to streaming replication when the `restore_command` fails. I first posted this to pgsql-admin mailing list, but now trying here as I got no response. *Expectation* I expect PostgreSQL to try switching to s

Re: Check whether a NOT NULL check constraint has been validated

Hi Adrian, > Now I am not sure what you did. > > Are you saying you used a CHECK constraint to check for NULL values? That's right. Something like: ALTER TABLE foo ADD CONSTRAINT bar_not_null CHECK (bar IS NOT NULL) NOT VALID > If so then pg_constraint.convalidated would work. You're rig

Re: How to use index in simple select

On Sat, Nov 29, 2025 at 12:57:46AM +0200, Andrus wrote: > Hi! > > Table has index on name column: > >         CREATE TABLE firma2.klient >         ( >             kood character(12) primary key, >              nimi character(100), >            ... >         ); > >        CREATE INDEX IF NOT EXIS