Re: postgresql-11 installation errors via deb package on ubuntu 16

Re: Vijaykumar Jain 2019-03-18 <CAE7uO5iYDWe4rcH+rDw6NOd_HX75sUaggouL-5FjzjZGbBgqYA(at)mail(dot)gmail(dot)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