Re: postgresql-11 installation errors via deb package on ubuntu 16 - Mailing list pgsql-pkg-debian

From Christoph Berg
Subject Re: postgresql-11 installation errors via deb package on ubuntu 16
Date
Msg-id 20190319100457.GC23312@msg.df7cb.de
Whole thread Raw
In response to postgresql-11 installation errors via deb package on ubuntu 16  (Vijaykumar Jain <vjain@opentable.com>)
Responses Re: [External] Re: postgresql-11 installation errors via deb packageon ubuntu 16
List pgsql-pkg-debian
Re: Vijaykumar Jain 2019-03-18 <CAE7uO5iYDWe4rcH+rDw6NOd_HX75sUaggouL-5FjzjZGbBgqYA@mail.gmail.com>
> Hey Guys,
> 
> I hope this is the right dist.

Hi,

it is, thanks for the report.

> we are having issues reported similar to
> https://stackoverflow.com/questions/2748607/how-to-thoroughly-purge-and-reinstall-postgresql-on-ubuntu
> which was ages back :) , but it is repeated.

> Setting up postgresql-11 (11.2-1.pgdg16.04+1) ...
> Unescaped left brace in regex is deprecated, passed through in regex;
> marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
> /usr/sbin/pam_getenv line 78.

(This is a bug in the pam package, not in postgresql-*.)

> Configuring already existing cluster (configuration:
> /etc/postgresql/11/main, data: /var/lib/postgresql/11/main, owner:
> 112:118)
> Error: move_conffile: required configuration file
> /var/lib/postgresql/11/main/postgresql.conf does not exist
> Error: could not create default cluster. Please create it manually with
> 
>   pg_createcluster 11 main --start

This happens when you didn't fully remove the old cluster and
/var/lib/postgresql/11/main is still present:

$ sudo pg_createcluster 11 foo
$ sudo rm -rf /etc/postgresql/11/foo/
$ sudo pg_createcluster 11 foo
Configuring already existing cluster (configuration: /etc/postgresql/11/foo, data: /var/lib/postgresql/11/foo, owner:
111:118)
Error: move_conffile: required configuration file /var/lib/postgresql/11/foo/postgresql.conf does not exist

To fix, simply delete the data directory.

Christoph


pgsql-pkg-debian by date:

Previous
From: Vijaykumar Jain
Date:
Subject: postgresql-11 installation errors via deb package on ubuntu 16
Next
From: "Fred .Flintstone"
Date:
Subject: PostgreSQL pollutes the file system