package postgresql-16 16.2-1ubuntu4 failed to install/upgrade: installed postgresql-16 package post-installation script subprocess returned error exit status 127

[Amir Shahzad]

error postgres

ProblemType: Package
DistroRelease: Ubuntu 24.04
Package: postgresql-16 16.2-1ubuntu4
ProcVersionSignature: Ubuntu 6.8.0-31.31-generic 6.8.1
Uname: Linux 6.8.0-31-generic x86_64
ApportVersion: 2.28.1-0ubuntu2
AptOrdering:
 postgresql-client-common:amd64: Install
 NULL: ConfigurePending
Architecture: amd64
CasperMD5CheckResult: pass
Date: Wed May 8 03:59:40 2024
ErrorMessage: installed postgresql-16 package post-installation script subprocess returned error exit status 127
InstallationDate: Installed on 2024-04-15 (22 days ago)
InstallationMedia: Ubuntu 22.04.4 LTS "Jammy Jellyfish" - Release amd64 (20240220)
Python3Details: /usr/bin/python3.12, Python 3.12.3, python3-minimal, 3.12.3-0ubuntu1
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.22.6ubuntu6
 apt 2.7.14build2
SourcePackage: postgresql-16
Title: package postgresql-16 16.2-1ubuntu4 failed to install/upgrade: installed postgresql-16 package post-installation script subprocess returned error exit status 127
UpgradeStatus: Upgraded to noble on 2024-05-07 (1 days ago)

[Paulo Flabiano Smorigo (pfsmorigo)]

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.

[Paride Legovini (paride)]

Hello from the attached logs this looks like a local configuration issue rather than a bug in Ubuntu. I'm marking this bug as Invalid. If you don't agree with this, please comment back explaining why you believe this is actually a bug in Ubuntu and change the bug status back to New. Thanks!

-- relevant log excerpt --

Error: clusters must not be owned by root
Error: could not create default cluster. Please create it manually with

  pg_createcluster 16 main --start

or a similar command (see 'man pg_createcluster').