On Mon, 7 Jun 2021, Tom Lane wrote:
I think you could clarify things quite a bit by enabling log_connections and log_statement, and then watching the postmaster log while you run the app.
Tom, In /var/log/postgresql-12 the shut-down and restart so an error I don't understand: 2021-06-07 08:46:51.980 PDT [1455] LOG: received smart shutdown request 2021-06-07 08:46:51.983 PDT [1455] LOG: background worker "logical replication launcher" (PID 1462) exited with exit code 1 2021-06-07 08:46:51.984 PDT [1457] LOG: shutting down 2021-06-07 08:46:51.998 PDT [1455] LOG: database system is shut down 2021-06-07 08:46:55.375 PDT [6708] LOG: starting PostgreSQL 12.2 on x86_64-slackware-linux-gnu, compiled by gcc (GCC) 5.5.0, 64-bit 2021-06-07 08:46:55.375 PDT [6708] LOG: listening on IPv4 address "127.0.0.1", port 5432 2021-06-07 08:46:55.378 PDT [6708] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2021-06-07 08:46:55.394 PDT [6709] LOG: database system was shut down at 2021-06-07 08:46:51 PDT 2021-06-07 08:46:55.398 PDT [6708] LOG: database system is ready to accept connections 2021-06-07 08:47:21.108 PDT [6734] ERROR: column pg_attrdef.adsrc does not exist at character 128 2021-06-07 08:47:21.108 PDT [6734] STATEMENT: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.attnotnull, pg_attribute.attlen, pg_attribute.atttypmod, pg_attrdef.adsrc from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) where pg_table_is_visible(pg_class.oid) and pg_class.relname = 'industrytypes' and pg_attribute.attnum > 0 and pg_attribute.attrelid = pg_class.oid and pg_attribute.attisdropped = false order by pg_attribute.attnum Fixing this error might well fix the issues I'm experiencing; I don't know where to start. Thanks, Rich
