Oh goodness it's even worse as pg_restore can't read the archive from the
first pg_dump:

pg_dump -h myhost -p 5432 -f mydb.pgdmp mydb
pg_restore -l mydb.pgdmp

pg_restore: [archiver] input file does not appear to be a valid archive


On Fri, 10 Jan 2003, Laurette Cisneros wrote:

> This works:
> pg_dump -h myhost -p 5432 -f mydb.cpgdmp mydb
> This does not:
> pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb
> Segmentation fault (core dumped)
> Nor does this:
> pg_dump -h myhost -p 5432 -Ft -f mydb.cpgdmp mydb
> (but I need the -Fc badly as my dbs backup up to large files)
> Here's a stack track (if needed):
> (adb) bt
> #0  0x080562a6 in WriteStr (AH=0x8074638,
>     c=0x6c627570 <Address 0x6c627570 out of bounds>) at
> pg_backup_archiver.c:1519
> #1  0x080569b2 in WriteToc (AH=0x8074638) at pg_backup_archiver.c:1851
> #2  0x080594b2 in _CloseArchive (AH=0x8074638) at pg_backup_custom.c:802
> #3  0x080545ef in CloseArchive (AHX=0x8074638) at pg_backup_archiver.c:113
> #4  0x0804a846 in main (argc=9, argv=0xbffff4cc) at pg_dump.c:645
> #5  0x401ef306 in __libc_start_main (main=0x8049db0 <main>, argc=9,
>     ubp_av=0xbffff4cc, init=0x8049634 <_init>, fini=0x8064720 <_fini>,
>     rtld_fini=0x4000d2dc <_dl_fini>, stack_end=0xbffff4bc)
>     at ../sysdeps/generic/libc-start.c:129
> Thanks,

Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
Life is an SQL old chum...

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to