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@debian.org>
Cc: pgsql-pkg-debian@postgresql.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
foundbelow (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]@[unknown] LOG:  incomplete startup packet
2016-11-18 09:50:30 MST [7478-1] postgres@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@postgres STATEMENT:  create extension postgis;
2016-11-18 09:50:52 MST [7482-1] postgres@gisb FATAL:  database "gisb" does not exist
2016-11-18 09:51:03 MST [7490-1] postgres@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@gisdb STATEMENT:  create extension postgis;

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

Re: Baker, Matthew 2016-11-17 <C8A1C896CD0F954B80CE89A7BCAB3F9E0173C736FD@MBXPDCe.dpsk12.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
havesome 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'sbeen a gazillion of bug reports about it like yours, but the PAM people haven't fixed it yet :( 

Christoph