package postgresql-9.3 9.3.6-0ubuntu0.14.04 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[sansen]

Description: Ubuntu 14.04.1 LTS
Release: 14.04

postgresql-9.3:
  Installé : 9.3.6-0ubuntu0.14.04
  Candidat : 9.3.6-0ubuntu0.14.04
 Table de version :
 *** 9.3.6-0ubuntu0.14.04 0
        500 http://fr.archive.ubuntu.com/ubuntu/ trusty-security/main amd64 Packages
        500 http://fr.archive.ubuntu.com/ubuntu/ trusty-updates/main amd64 Packages
        100 /var/lib/dpkg/status
     9.3.4-1 0
        500 http://fr.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages

ProblemType: Package
DistroRelease: Ubuntu 14.04
Package: postgresql-9.3 9.3.6-0ubuntu0.14.04
ProcVersionSignature: Ubuntu 3.13.0-45.74-generic 3.13.11-ckt13
Uname: Linux 3.13.0-45-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.14.1-0ubuntu3.6
Architecture: amd64
Date: Thu Feb 12 09:15:44 2015
DuplicateSignature: package:postgresql-9.3:9.3.6-0ubuntu0.14.04:subprocess installed post-installation script returned error exit status 1
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2014-08-30 (165 days ago)
InstallationMedia: Ubuntu-GNOME 14.04.1 LTS "Trusty Tahr" - Release amd64 (20140722.2)
SourcePackage: postgresql-9.3
Title: package postgresql-9.3 9.3.6-0ubuntu0.14.04 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Ron Bentley (rtbentley)]

In my particular case, this error appeared to be related to permissions in the /var/run/postgresql directory. Postgres could not start because it could not modify files in that directory.

I have not been watching the Postgres installations carefully enough in the past. I now have both a postgres user and a postgres-xc user; I am not sure when I picked up each. After this upgrade the directory /var/run/postgresql and its contents were owned by postgres-xc but the Postgres server was running under the postgres user. I do not know what the status was before the upgrade.

I ran this command:

  chown -R postgres:postgres /var/run/postgresql

PostgreSQL starts and apt is content that the installation is complete.

The bug itself is a pretty generic "failed to install package." It is quite possible the problem I encountered is completely different from the problems others have.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.