Package: postgresql-13-cron
Version: 1.3.0-2.pgdg100+1
Severity: important
Dear Maintainer,
a pg_upgrade from v12 to v13
(with a working pg_cron (postgresql-12-cron) on the v12 cluster)
does not seem to work.
postgresql-13-cron is also installed.
the extension, though installed, is not found during the upgrade.
(other extensions are found, so i'm guessing this not a issue of pg_upgrade)
the configuration parameter "cron.database_name"
and the extension "pg_cron" reported as the problem.
repository: apt.postgresql.org for buster
(even though this is not the main debian repository,
if i'm not mistaking more or less maintainers work on this,
and eventually this will into debian)
hth,
Wim
the error log:
# pg_upgradecluster 12 2021 | tee &> /tmp/u_12_2021_13
ERROR: unrecognized configuration parameter "cron.database_name"
CONTEXT: PL/pgSQL function inline_code_block line 3 at IF
ERROR: extension "pg_cron" does not exist
ERROR: schema "cron" does not exist
ERROR: schema "cron" does not exist
pg_restore: error: could not execute query: ERROR: schema "cron" does not exist
Command was: ALTER TABLE cron.job DISABLE TRIGGER ALL;
pg_restore: error: could not execute query: ERROR: schema "cron" does not exist
Command was: COPY "cron"."job" ("jobid", "schedule", "command", "nodename",
"nodeport", "database", "username", "active") FROM stdin;
pg_restore: error: could not execute query: ERROR: schema "cron" does not exist
Command was: ALTER TABLE cron.job ENABLE TRIGGER ALL;
pg_restore: from TOC entry 2914; 0 0 SEQUENCE SET jobid_seq wim
pg_restore: error: could not execute query: ERROR: schema "cron" does not exist
LINE 1: SELECT pg_catalog.setval('"cron"."jobid_seq"', 9, true);
^
Command was: SELECT pg_catalog.setval('"cron"."jobid_seq"', 9, true);
-- System Information:
Debian Release: 10.8
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.19.0-13-amd64 (SMP w/4 CPU cores)
Locale: LANG=nl_BE.UTF-8, LC_CTYPE=nl_BE.UTF-8 (charmap=UTF-8),
LANGUAGE=nl_BE:nl (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages postgresql-13-cron depends on:
ii libc6 2.28-10
ii libpq5 13.1-1.pgdg100+1
ii postgresql-13 13.1-1.pgdg100+1
postgresql-13-cron recommends no packages.
postgresql-13-cron suggests no packages.
-- no debconf information
