pg_restore crushes if dump data includes large objects...
--
Tatsuo Ishii
[t-ishii@srapc1474 7.1]$ createdb test
CREATE DATABASE
[t-ishii@srapc1474 7.1]$ psql -c "select lo_import('/boot/vmlinuz')" testlo_import
----------- 20736
(1 row)
[t-ishii@srapc1474 7.1]$ pg_dump -F c -b test > test.db
[t-ishii@srapc1474 7.1]$ createdb test2
CREATE DATABASE
[t-ishii@srapc1474 7.1]$ pg_restore -d test2 test.db
Segmentation fault (core dumped)
[t-ishii@srapc1474 7.1]$ gdb pg_restore core
GNU gdb 5.0
Copyright 2000 Free Software Foundation, Inc.
[snip]
#0 0x804abd4 in _enableTriggersIfNecessary (AH=0x8057d30, te=0x0, ropt=0x8057c90) at pg_backup_archiver.c:474
474 ahprintf(AH, "UPDATE pg_class SET reltriggers = "
(gdb) where
#0 0x804abd4 in _enableTriggersIfNecessary (AH=0x8057d30, te=0x0, ropt=0x8057c90) at pg_backup_archiver.c:474
#1 0x804a8c0 in RestoreArchive (AHX=0x8057d30, ropt=0x8057c90) at pg_backup_archiver.c:336
#2 0x804a03e in main (argc=4, argv=0x7ffff864) at pg_restore.c:312
#3 0x2ab9796b in __libc_start_main (main=0x8049a40 <main>, argc=4, argv=0x7ffff864, init=0x8049394 <_init>,
fini=0x8052d2c<_fini>, rtld_fini=0x2aab5d00 <_dl_fini>, stack_end=0x7ffff85c) at
../sysdeps/generic/libc-start.c:92
(gdb)