From: | "Baker, Matthew" <MATTHEW_BAKER(at)dpsk12(dot)org> |
---|---|
To: | Christoph Berg <myon(at)debian(dot)org> |
Cc: | "pgsql-pkg-debian(at)postgresql(dot)org" <pgsql-pkg-debian(at)postgresql(dot)org> |
Subject: | Re: Error with APT installation (regex warning, PostGIS fails) |
Date: | 2016-11-18 17:18:40 |
Message-ID: | C8A1C896CD0F954B80CE89A7BCAB3F9E0173C739B2@MBXPDCe.dpsk12.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-pkg-debian |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Baker, Matthew | 2016-11-18 21:38:09 | Re: Error with APT installation (regex warning, PostGIS fails) |
Previous Message | apt.postgresql.org repository | 2016-11-18 16:13:45 | pgbackrest updated to version 1.11-1.pgdg+1 |