Thread: Error with APT installation (regex warning, PostGIS fails)
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
- 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
(...)
Setting up pgdg-keyring (2014.1) ...
Removing apt.postgresql.org key from trusted.gpg: OK
Importing apt.postgresql.org key: OK
Setting up postgresql-client-common (177.pgdg16.04+1) ...
Setting up postgresql-client-9.5 (9.5.5-1.pgdg16.04+1) ...
update-alternatives: using /usr/share/postgresql/9.5/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (177.pgdg16.04+1) ...
Adding user postgres to group ssl-cert
Creating config file /etc/postgresql-common/createcluster.conf with new version
Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
en_us
Removing obsolete dictionary files:
Setting up postgresql-9.5 (9.5.5-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.
Creating new cluster 9.5/main ...
config /etc/postgresql/9.5/main
data /var/lib/postgresql/9.5/main
locale en_US.UTF-8
socket /var/run/postgresql
port 5432
update-alternatives: using /usr/share/postgresql/9.5/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
Processing triggers for libc-bin (2.23-0ubuntu4) ...
Processing triggers for systemd (229-4ubuntu12) ...
Processing triggers for ureadahead (0.100.0-19) ...
Many thanks and hope there is a solution...
Matthew Baker
Denver Public Schools
Denver, CO, USA
matthew_baker@dpsk12.org
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
- 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
(...)
Setting up pgdg-keyring (2014.1) ...
Removing apt.postgresql.org key from trusted.gpg: OK
Importing apt.postgresql.org key: OK
Setting up postgresql-client-common (177.pgdg16.04+1) ...
Setting up postgresql-client-9.5 (9.5.5-1.pgdg16.04+1) ...
update-alternatives: using /usr/share/postgresql/9.5/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (177.pgdg16.04+1) ...
Adding user postgres to group ssl-cert
Creating config file /etc/postgresql-common/createcluster.conf with new version
Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
en_us
Removing obsolete dictionary files:
Setting up postgresql-9.5 (9.5.5-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.
Creating new cluster 9.5/main ...
config /etc/postgresql/9.5/main
data /var/lib/postgresql/9.5/main
locale en_US.UTF-8
socket /var/run/postgresql
port 5432
update-alternatives: using /usr/share/postgresql/9.5/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
Processing triggers for libc-bin (2.23-0ubuntu4) ...
Processing triggers for systemd (229-4ubuntu12) ...
Processing triggers for ureadahead (0.100.0-19) ...
Many thanks and hope there is a solution...
Matthew Baker
Denver Public Schools
Denver, CO, USA
matthew_baker@dpsk12.org
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 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 theAPT repo verbatim, and when using the instructions we've modified above for the PostGIS install...also throws an errorwhen 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
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
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