BUG #8157: pg_dump and pg_dumpall fail when extension postgis_tiger_geocoder is installed

From: leif(at)lako(dot)no
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8157: pg_dump and pg_dumpall fail when extension postgis_tiger_geocoder is installed
Date: 2013-05-14 08:19:51
Message-ID: E1UcASd-0005m4-SQ@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8157
Logged by: Leif Gunnar Erlandsen
Email address: leif(at)lako(dot)no
PostgreSQL version: Unsupported/Unknown
Operating system: Linux Fedora 18
Description:

-bash-4.2$ psql
psql (9.3beta1)
Type "help" for help.

postgres=# 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=# \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 "="
LINE 1: ...rd, token, is_custom FROM tiger.pagc_gaz is_custom=true) TO ...
^
pg_dump: [archiver (db)] query was: COPY (SELECT id, seq, word, stdword,
token, is_custom FROM tiger.pagc_gaz is_custom=true) TO stdout;
pg_dumpall: pg_dump failed on database "postgres", exiting
-bash-4.2$ which pg_dumpall
/usr/pgsql-9.3/bin/pg_dumpall

Browse pgsql-bugs by date

  From Date Subject
Next Message csibe1985.12 2013-05-14 11:38:12 BUG #8159: PostgreSQlk is not working
Previous Message Amit Kapila 2013-05-14 05:58:47 Re: Odd Behavior After Multiple Deletes