package postgresql-11 11.5-1 failed to install/upgrade: installed postgresql-11 package post-installation script subprocess returned error exit status 1

[watson]

Occurred during server upgrade to 19.10 from 19.04.

ProblemType: Package
DistroRelease: Ubuntu 19.10
Package: postgresql-11 11.5-1
ProcVersionSignature: Ubuntu 5.0.0-32.34-generic 5.0.21
Uname: Linux 5.0.0-32-generic x86_64
ApportVersion: 2.20.11-0ubuntu8
Architecture: amd64
Date: Fri Oct 25 18:01:30 2019
ErrorMessage: installed postgresql-11 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2019-10-16 (8 days ago)
InstallationMedia: Ubuntu-Server 19.04 "Disco Dingo" - Release amd64 (20190416.2)
Python3Details: /usr/bin/python3.7, Python 3.7.5rc1, python3-minimal, 3.7.5-1
PythonDetails: /usr/bin/python2.7, Python 2.7.17rc1, python-minimal, 2.7.17-1
RelatedPackageVersions:
 dpkg 1.19.7ubuntu2
 apt 1.9.4
SourcePackage: postgresql-11
Title: package postgresql-11 11.5-1 failed to install/upgrade: installed postgresql-11 package post-installation script subprocess returned error exit status 1
UpgradeStatus: Upgraded to eoan on 2019-10-25 (0 days ago)

[Andreas Hasenack (ahasenack)]

Thanks for taking the time and filing this bug in Ubuntu.

Looking at the data you provided, I wonder:
● postgresql.service - PostgreSQL database server
   Loaded: loaded (]8;;file://zombie/etc/systemd/system/postgresql.service/etc/systemd/system/postgresql.service]8;;; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Fri 2019-10-25 18:01:30 UTC; 10ms ago
     Docs: ]8;;man:postgres(1)man:postgres(1)]8;;
  Process: 24862 ExecStart=/var/lib/postgresql/12/main -D /usr/local/pgsql/data (code=exited, status=203/EXEC)
 Main PID: 24862 (code=exited, status=203/EXEC)

Why is there mention of postgresql version 12 in there? Eoan (19.10) shipped with postgresql 11.5.

You also seem to have a systemd override in place (/etc/systemd/system/postgresql.service? file://zombie/etc/systemd/system/postgresql.service?).

[Launchpad Janitor (janitor)]

[Expired for postgresql-11 (Ubuntu) because there has been no activity for 60 days.]