I get a segmentation fault in pg_dump (8.2.3 on a Linux Fedora Core 5 system) when dumping some (but not all) of the sequences in the public schema:.
Here's the output from /usr/local/pgsql/bin/pg_dump -v -t uscf_dues_dues_key_seq -U postgres uscf >uscf_dues_dues_key_seq.seq
pg_dump: reading schemas
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined conversions
pg_dump: reading user-defined tables
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: reading type casts
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading constraints
pg_dump: reading triggers
pg_dump: reading dependency data
pg_dump: saving encoding = SQL_ASCII
pg_dump: saving standard_conforming_strings = off
./seq.job: line 1: 31367 Segmentation fault /usr/local/pgsql/bin/pg_dump -v
-t uscf_dues_dues_key_seq -U postgres uscf >uscf_dues_dues_key_seq.seq
Any ideas what to try?
--
Mike Nolan