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