package postgresql-12 (not installed) failed to install/upgrade: new postgresql-12 package pre-installation script subprocess returned error exit status 127

[Deepak]

postgresql-12 not installing

ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: postgresql-12 (not installed)
ProcVersionSignature: Ubuntu 5.8.0-40.45~20.04.1-generic 5.8.18
Uname: Linux 5.8.0-40-generic x86_64
NonfreeKernelModules: wl
ApportVersion: 2.20.11-0ubuntu27.14
AptOrdering:
 postgresql-12:amd64: Install
 NULL: ConfigurePending
Architecture: amd64
CasperMD5CheckResult: skip
Date: Thu Jan 28 14:12:47 2021
DpkgTerminalLog:
 Preparing to unpack .../postgresql-12_12.5-1.pgdg20.04+1_amd64.deb ...
 /var/lib/dpkg/tmp.ci/preinst: 11: .: Can't open /usr/share/postgresql-common/maintscripts-functions
 dpkg: error processing archive /var/cache/apt/archives/postgresql-12_12.5-1.pgdg20.04+1_amd64.deb (--unpack):
  new postgresql-12 package pre-installation script subprocess returned error exit status 127
ErrorMessage: new postgresql-12 package pre-installation script subprocess returned error exit status 127
InstallationDate: Installed on 2021-01-27 (0 days ago)
InstallationMedia: Ubuntu 20.04.1 LTS "Focal Fossa" - Release amd64 (20200731)
Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.19.7ubuntu3
 apt 2.0.4
SourcePackage: postgresql-12
Title: package postgresql-12 (not installed) failed to install/upgrade: new postgresql-12 package pre-installation script subprocess returned error exit status 127
UpgradeStatus: No upgrade log present (probably fresh install)

[Alex Murray (alexmurray)]

Thanks for taking the time to report this bug and helping to make Ubuntu better. We appreciate the difficulties you are facing, but this appears to be a "regular" (non-security) bug. I have unmarked it as a security issue since this bug does not show evidence of allowing attackers to cross privilege boundaries nor directly cause loss of data/privacy. Please feel free to report any other bugs you may find.

[Christian Ehrhardt  (paelzer)]

This file is provided by:
postgresql-client-common: /usr/share/postgresql-common/maintscripts-functions

And the one you configure has a dependency:
apt-cache show postgresql-12 | grep commo
Depends: locales | locales-all, postgresql-client-12, postgresql-common (>= 182~)

Therefore postgresql-client-common should be unpacked before postgresql-12 is configured.
I wonder if there are any 3rd party packages and/or repositories active.

Could you report:
$ apt-cache policy postgresql-client-common postgresql-12

Also the bug report misses the usually attached console output of the install/upgrade that would have shown the ordering of the two packages - if you can reproduce this and attach the console output please?

[Launchpad Janitor (janitor)]

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