postgresql-11 installation errors via deb package on ubuntu 16

From: Vijaykumar Jain <vjain(at)opentable(dot)com>
To: pgsql-pkg-debian(at)postgresql(dot)org
Subject: postgresql-11 installation errors via deb package on ubuntu 16
Date: 2019-03-18 19:47:36
Message-ID: CAE7uO5iYDWe4rcH+rDw6NOd_HX75sUaggouL-5FjzjZGbBgqYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

Hey Guys,

I hope this is the right dist.

i am installing postgresql-11 via
deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main 11

on a ubuntu16 xenial machine.
Let me know if this is not the right list, and i'll try to search the
right list.

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.

the error messages:
error messages from /var/log/apt/term.log

Preparing to unpack .../postgresql-11_11.2-1.pgdg16.04+1_amd64.deb ...
Unpacking postgresql-11 (11.2-1.pgdg16.04+1) ...
Processing triggers for postgresql-common (199.pgdg16.04+1) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
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.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?<!\\)\${ <-- HERE ([^}]+)}/ at
/usr/sbin/pam_getenv line 78.
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

----
all installation happen via
deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main 11

while monitoring /var/lib/postgresql folder (during the
postgresql-common and postgresql-11 installation)
i do not see creation of /var/lib/postgresql/11/main/postgresql.conf at all.
and since the config is not created
pg_createcluster fails as it could not move this config to
/etc/postgresql/11/main/postgresql.conf

and hence the above error.
i guess for some reason, initdb? is not able to generate the default configs?
i am not able to reproduce this, it happends only occasionally, (1 in
5 runs) but breaks out automation of server provisioning :(

in a good run, this is what we see

fixing permissions on existing directory /var/lib/postgresql/11/main ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

/usr/lib/postgresql/11/bin/pg_ctl -D /var/lib/postgresql/11/main
-l logfile start

Ver Cluster Port Status Owner Data directory Log file
ESC[31m11 main 5432 down postgres /var/lib/postgresql/11/main
/var/log/postgresql/postgresql-11-main.logESC[0m
update-alternatives: using
/usr/share/postgresql/11/man/man1/postmaster.1.gz to provide
/usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode

https://doxygen.postgresql.org/initdb_8c.html#aa3dcebf3471677bce0aaceeaec0e8fa6
is this the code block that is create the datadir and default configs?

I'll be happy to be told i am doing things incorrectly if that is the case.

Regards,
Vijay

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Christoph Berg 2019-03-19 10:04:57 Re: postgresql-11 installation errors via deb package on ubuntu 16
Previous Message apt.postgresql.org Repository Update 2019-03-12 18:43:22 pgbackrest updated to version 2.11-1.pgdg+1