Обсуждение: Pg_Dumpall error?
I've done numerous dumps, but I've never seen this type of error before: pg_dumpall > datamart.out pg_dump: [archiver] could not write to output file (36 != 97) pg_dumpall: pg_dump failed on bdc_oz, exiting Any ideas? I'm running Pg 7.3.2 TIA Patrick Hatcher
Forgive the stupid question, since I'm completely unfamiliar with the logging changes Tom is busy working on, but would it be worthwhile to have error messages/asserts include a function/filename where the assert failed? (I'm assuming this is an assert failure). If the assert code could be easily changed to add that info, it might be helpful to those not intimately familiar with the code. Just a thought. On Mon, Jun 30, 2003 at 03:03:52PM -0700, Patrick Hatcher wrote: > I've done numerous dumps, but I've never seen this type of error before: > > pg_dumpall > datamart.out > pg_dump: [archiver] could not write to output file (36 != 97) > pg_dumpall: pg_dump failed on bdc_oz, exiting > > Any ideas? > I'm running Pg 7.3.2 > > TIA > Patrick Hatcher > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- Jim C. Nasby, Database Consultant jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
i'm starting to research conversion from oracle 8i to postgresql on behalf of a client. in looking at the techdocs site, i found that the following two links are dead: Oracle to Postgres Conversion by James Shannon, Ben Adida, and Don Baccus Oracle Style Data Dictionary views for PostgreSQL by Chris Brown anyone know where i can find these articles? anyone have any other good web sites, papers, or other relevant items? thanks, richard -- Richard Welty rwelty@averillpark.net Averill Park Networking 518-573-7592 Unix, Linux, IP Network Engineering, Security
<p>Actually I think I may be able to answer my own question. I think my sysAdmin added something to the Linux box and causedthe problem. I started to get swap errors with error messages about system drive out of space. This shouldn't be aproblem since there's only 6gigs out of 90+gigs of space on the thing. I also noticed that if I ran it a few times, I gotdifferent numbers in the error message: could not write to output file (X != 97).<p>So while the error message wasn'ttotally apparent, it made sense after I realized the space problem.<p>><br />><br />>Patrick Hatcher<br /><p>><br />><font size="2"><b>"Jim C. Nasby" <jim@nasby.net></b></font><br />><font size="2">06/30/2003 08:11PM EST</font><br />><br />> <font size="2">To:</font> <font size="2">Patrick Hatcher <PHatcher@macys.com></font><br/>> <font size="2">cc:</font> <font size="2">pgsql-general@postgresql.org</font><br/>> <font size="2">bcc:</font><br />> <font size="2">Subject:</font><font size="2">Re: [GENERAL] Pg_Dumpall error?</font><br />> <br />><br />><p>><fontface="Courier">Forgive the stupid question, since I'm completely unfamiliar with the<br />>logging changesTom is busy working on, but would it be worthwhile to<br />>have error messages/asserts include a function/filenamewhere the assert<br />>failed? (I'm assuming this is an assert failure). If the assert code<br />>couldbe easily changed to add that info, it might be helpful to those<br />>not intimately familiar with the code.<br/>></font><br />><font face="Courier">Just a thought.<br />></font><br />><font face="Courier">On Mon,Jun 30, 2003 at 03:03:52PM -0700, Patrick Hatcher wrote:<br />>> I've done numerous dumps, but I've never seenthis type of error before:<br />>><br />>> pg_dumpall > datamart.out<br />>> pg_dump: [archiver]could not write to output file (36 != 97)<br />>> pg_dumpall: pg_dump failed on bdc_oz, exiting<br />>><br/>>> Any ideas?<br />>> I'm running Pg 7.3.2<br />>><br />>> TIA<br />>> PatrickHatcher<br />>><br />>><br />>><br />>><br />>> ---------------------------(end of broadcast)---------------------------<br/>>> TIP 7: don't forget to increase your free space map settings<br />>><br/>></font><br />><font face="Courier">--<br />>Jim C. Nasby, Database Consultant jim@nasby.net<br/>>Member: Triangle Fraternity, Sports Car Club of America<br />>Give your computer some brain candy!www.distributed.net Team #1828<br />></font><br />><font face="Courier">Windows: "Where do you want to go today?"<br/>>Linux: "Where do you want to go tomorrow?"<br />>FreeBSD: "Are you guys coming, or what?"</font>
"Patrick Hatcher" <PHatcher@macys.com> writes: > I've done numerous dumps, but I've never seen this type of error before: > pg_dumpall > datamart.out > pg_dump: [archiver] could not write to output file (36 != 97) > pg_dumpall: pg_dump failed on bdc_oz, exiting Out of disk space, perhaps? I believe the message is complaining that an fwrite didn't write all it was told to. regards, tom lane
an IPv6 data type is on the todo list, but it looks like it's been there a while. is there any work being done on this, and is there an ETA? i have a project that could use it, but if it wasn't coming soon (say in 7.4), i can work around it. it'd just be nice and all that. richard -- Richard Welty rwelty@averillpark.net Averill Park Networking 518-573-7592 Unix, Linux, IP Network Engineering, Security
It will be in 7.4. --------------------------------------------------------------------------- Richard Welty wrote: > an IPv6 data type is on the todo list, but it looks like it's been there a > while. > > is there any work being done on this, and is there an ETA? i have a project > that could use it, but if it wasn't coming soon (say in 7.4), i can work > around it. it'd just be nice and all that. > > richard > -- > Richard Welty rwelty@averillpark.net > Averill Park Networking 518-573-7592 > Unix, Linux, IP Network Engineering, Security > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073