[Pkg-postgresql-public] Bug#916299: postgresql-11: starts with error after upgrade from stretch to buster

[Christoph Berg]

Re: Andreas Beckmann 2018-12-12 <154464601477.7884.18297936684525003467.reportbug at zam581.zam.kfa-juelich.de>
> - start with a minimal stretch chroot, allow starting the postgresql service
> - install postgresql
> - switch apt sources to buster
> - install postgresql/buster
> *** it failed here to start the -11 server ***

This is #912360, but cluster_port_ready() from PgCommon.pm suppresses
the psql output so this is hard to see. With some debug printing:

$ sudo pg_ctlcluster 11 main start
/usr/lib/postgresql/11/bin/pg_ctl /usr/lib/postgresql/11/bin/pg_ctl start -D /var/lib/postgresql/11/main -l /var/log/postgresql/postgresql-11-main.log -s -o  -c config_file="/etc/postgresql/11/main/postgresql.conf"
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
/usr/lib/postgresql/11/bin/psql: symbol lookup error: /usr/lib/postgresql/11/bin/psql: undefined symbol: append_history
The PostgreSQL server failed to start. Please check the log output:
2019-01-09 13:18:07.128 CET [31787] LOG:  listening on IPv6 address "::1", port 5433
2019-01-09 13:18:07.128 CET [31787] LOG:  listening on IPv4 address "127.0.0.1", port 5433
2019-01-09 13:18:07.128 CET [31787] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5433"
2019-01-09 13:18:07.135 CET [31788] LOG:  database system was shut down at 2019-01-09 13:18:06 CET
2019-01-09 13:18:07.138 CET [31787] LOG:  database system is ready to accept connections
2019-01-09 13:18:07.718 CET [31795] [unknown]@[unknown] LOG:  incomplete startup packet

Christoph