Re: [HACKERS] 7.3 pg_dump with -Fc option crashes
> We clearly need to have a 7.3.2, but I was thinking late January would > be about the right time frame. Bugs are still trickling in (eg, the > plpgsql one Neil just identified), and so far we've not seen anything > that would make me feel we need an immediate release ... I'm biased, but I think the SSL problems fixed since 7.3.1 are pretty big. 7.3.1 is still pretty much unuseable if SSL support is required. --Nate ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] 7.3 pg_dump with -Fc option crashes
Bruce Momjian <[EMAIL PROTECTED]> writes: > Are we near needing 7.3.2? We clearly need to have a 7.3.2, but I was thinking late January would be about the right time frame. Bugs are still trickling in (eg, the plpgsql one Neil just identified), and so far we've not seen anything that would make me feel we need an immediate release ... regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] 7.3 pg_dump with -Fc option crashes
Are we near needing 7.3.2? The contraint dump patch is post-7.3.1 too, and Tom applied a big fix recently to 7.3.X. --- Laurette Cisneros wrote: > That did the trick...fixed pg_dump! > > And, pg_restore works on it too! > > Yay, I can go home now. > > Thanks very much for your help! > > On Fri, 10 Jan 2003, Tom Lane wrote: > > > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > > This does not: > > > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > > > Segmentation fault (core dumped) > > > > If you have any comments on views, this is probably an instance of a > > known bug: > > > > 2002-12-27 12:10 tgl > > > > * src/bin/pg_dump/: pg_dump.c (REL7_3_STABLE), pg_dump.c: Remove > > overenthusiastic free'ing of comment dependencies; could lead to > > core dump in pg_dump when dumping views having comments. See bug > > #855. > > > > This fix postdates 7.3.1, but you could get the patch from the CVS > > server or the pgsql-bugs archives. > > > > regards, tom lane > > > > -- > Laurette Cisneros > The Database Group > (510) 420-3137 > NextBus Information Systems, Inc. > www.nextbus.com > -- > Life is an SQL old chum... > > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] 7.3 pg_dump with -Fc option crashes
That did the trick...fixed pg_dump! And, pg_restore works on it too! Yay, I can go home now. Thanks very much for your help! On Fri, 10 Jan 2003, Tom Lane wrote: > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > This does not: > > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > > Segmentation fault (core dumped) > > If you have any comments on views, this is probably an instance of a > known bug: > > 2002-12-27 12:10 tgl > > * src/bin/pg_dump/: pg_dump.c (REL7_3_STABLE), pg_dump.c: Remove > overenthusiastic free'ing of comment dependencies; could lead to > core dump in pg_dump when dumping views having comments. See bug > #855. > > This fix postdates 7.3.1, but you could get the patch from the CVS > server or the pgsql-bugs archives. > > regards, tom lane > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- Life is an SQL old chum... ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] 7.3 pg_dump with -Fc option crashes
Thanks. I've nulled all the "comment on view"s but still get it... On Fri, 10 Jan 2003, Tom Lane wrote: > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > This does not: > > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > > Segmentation fault (core dumped) > > If you have any comments on views, this is probably an instance of a > known bug: > > 2002-12-27 12:10 tgl > > * src/bin/pg_dump/: pg_dump.c (REL7_3_STABLE), pg_dump.c: Remove > overenthusiastic free'ing of comment dependencies; could lead to > core dump in pg_dump when dumping views having comments. See bug > #855. > > This fix postdates 7.3.1, but you could get the patch from the CVS > server or the pgsql-bugs archives. > > regards, tom lane > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- Life is an SQL old chum... ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 7.3 pg_dump with -Fc option crashes
Laurette Cisneros <[EMAIL PROTECTED]> writes: > This does not: > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > Segmentation fault (core dumped) If you have any comments on views, this is probably an instance of a known bug: 2002-12-27 12:10 tgl * src/bin/pg_dump/: pg_dump.c (REL7_3_STABLE), pg_dump.c: Remove overenthusiastic free'ing of comment dependencies; could lead to core dump in pg_dump when dumping views having comments. See bug #855. This fix postdates 7.3.1, but you could get the patch from the CVS server or the pgsql-bugs archives. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] 7.3 pg_dump with -Fc option crashes
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 Thanks, L. 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 ) 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=0xb4cc) at pg_dump.c:645 > #5 0x401ef306 in __libc_start_main (main=0x8049db0 , argc=9, > ubp_av=0xb4cc, init=0x8049634 <_init>, fini=0x8064720 <_fini>, > rtld_fini=0x4000d2dc <_dl_fini>, stack_end=0xb4bc) > at ../sysdeps/generic/libc-start.c:129 > > Thanks, > > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- Life is an SQL old chum... ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html