Thread: BUG #8157: pg_dump and pg_dumpall fail when extension postgis_tiger_geocoder is installed
BUG #8157: pg_dump and pg_dumpall fail when extension postgis_tiger_geocoder is installed
From
leif@lako.no
Date:
The following bug has been logged on the website:
Bug reference: 8157
Logged by: Leif Gunnar Erlandsen
Email address: leif@lako.no
PostgreSQL version: Unsupported/Unknown
Operating system: Linux Fedora 18
Description: =
-bash-4.2$ psql
psql (9.3beta1)
Type "help" for help.
postgres=3D# select extname,extowner,extnamespace,extrelocatable,extversion
from pg_extension ;
extname | extowner | extnamespace | extrelocatable |
extversion =
------------------------+----------+--------------+----------------+-------=
-----
plpgsql | 10 | 11 | f | 1.0
postgis | 10 | 2200 | t |
2.1.0beta2
postgis_topology | 10 | 17668 | f |
2.1.0beta2
fuzzystrmatch | 10 | 2200 | t | 1.0
postgis_tiger_geocoder | 10 | 17831 | f |
2.1.0beta2
(5 rows)
postgres=3D# \q
-bash-4.2$ pg_dump
pg_dump pg_dumpall =
-bash-4.2$ pg_dumpall > /dev/null
pg_dump: [archiver (db)] query failed: ERROR: syntax error at or near "=3D"
LINE 1: ...rd, token, is_custom FROM tiger.pagc_gaz is_custom=3Dtrue) TO ...
^
pg_dump: [archiver (db)] query was: COPY (SELECT id, seq, word, stdword,
token, is_custom FROM tiger.pagc_gaz is_custom=3Dtrue) TO stdout;
pg_dumpall: pg_dump failed on database "postgres", exiting
-bash-4.2$ which pg_dumpall
/usr/pgsql-9.3/bin/pg_dumpall