Re: Error with APT installation (regex warning, PostGIS fails)

All, I just fired up an Ubuntu 16.10 box (xenial) and things are working fine.

So perhaps this is a Linux Mint issue... that's where I was having the errors.

-m

-----Original Message-----
From: Baker, Matthew
Sent: Friday, November 18, 2016 10:19 AM
To: 'Christoph Berg' <myon(at)debian(dot)org>
Cc: pgsql-pkg-debian(at)postgresql(dot)org
Subject: RE: [pgsql-pkg-debian] Error with APT installation (regex warning, PostGIS fails)

Thank you, Christoph!

PostGIS still fails, though it says it is installed - the error in the log when creating the postgis extension can be found below (ERROR: could not open extension control file).

The remainder of the install seems to work just fine despite the errors with PAM (as per Christoph's

2016-11-18 09:47:36 MST [7286-1] LOG: database system was shut down at 2016-11-18 09:47:35 MST
2016-11-18 09:47:36 MST [7286-2] LOG: MultiXact member wraparound protections are now enabled
2016-11-18 09:47:36 MST [7285-1] LOG: database system is ready to accept connections
2016-11-18 09:47:36 MST [7290-1] LOG: autovacuum launcher started
2016-11-18 09:47:37 MST [7292-1] [unknown](at)[unknown] LOG: incomplete startup packet
2016-11-18 09:50:30 MST [7478-1] postgres(at)postgres ERROR: could not open extension control file "/usr/share/postgresql/9.5/extension/postgis.control": No such file or directory
2016-11-18 09:50:30 MST [7478-2] postgres(at)postgres STATEMENT: create extension postgis;
2016-11-18 09:50:52 MST [7482-1] postgres(at)gisb FATAL: database "gisb" does not exist
2016-11-18 09:51:03 MST [7490-1] postgres(at)gisdb ERROR: could not open extension control file "/usr/share/postgresql/9.5/extension/postgis.control": No such file or directory
2016-11-18 09:51:03 MST [7490-2] postgres(at)gisdb STATEMENT: create extension postgis;

-----Original Message-----
From: Christoph Berg [mailto:myon(at)debian(dot)org]
Sent: Friday, November 18, 2016 2:00 AM
To: Baker, Matthew <MATTHEW_BAKER(at)dpsk12(dot)org>
Cc: pgsql-pkg-debian(at)postgresql(dot)org
Subject: Re: [pgsql-pkg-debian] Error with APT installation (regex warning, PostGIS fails)

Re: Baker, Matthew 2016-11-17 <C8A1C896CD0F954B80CE89A7BCAB3F9E0173C736FD(at)MBXPDCe(dot)dpsk12(dot)org>
> All,
>
> A few errors have popped up today using the APT repo that have otherwise been rock solid for quite a while:
>
> 1) PostGIS does not install/load as it used to - no errors beyond what
> 2) below reports

Hi Matthew,

thanks for the report. However, we'd need some details on what exactly isn't working. Does the PostgreSQL server log have some more information?

> - Instructions usually used found here:
> http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS22UbuntuPGSQL95Apt
>
> 2) Strange error coming up that I can only paste and step aside... the
> error is thrown when using the instructions on the APT repo verbatim,
> and when using the instructions we've modified above for the PostGIS
> install...also throws an error when pulling PG v9.6 and v9.5

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

These are just warnings that you can ignore. The problem isn't even in PostgreSQL, but in PAM (/usr/sbin/pam_getenv). There's been a gazillion of bug reports about it like yours, but the PAM people haven't fixed it yet :(

Christoph