Re: Pg_Dumpall error?

Поиск
Список
Период
Сортировка
От Patrick Hatcher
Тема Re: Pg_Dumpall error?
Дата
Msg-id OFAE0B87F0.26C0D909-ON88256D56.00144A85@fds.com
обсуждение исходный текст
Ответ на Pg_Dumpall error?  ("Patrick Hatcher" <PHatcher@macys.com>)
Список pgsql-general
<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> 

В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Jacobs
Дата:
Сообщение: Re: PlPython
Следующее
От: "Madhavi Daroor"
Дата:
Сообщение: 2 different versions of postgres on the same system