Re: Pg_Dumpall error?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: "" Jim C(dot)Nasby " <jim" <jim(at)nasby(dot)net>
Cc: Patrick Hatcher <PHatcher(at)macys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Pg_Dumpall error?
Date: 2003-07-01 03:41:38
Message-ID: OFAE0B87F0.26C0D909-ON88256D56.00144A85@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<P>Actually I think I may be able to answer my own question. &nbsp;I think my sysAdmin added something to the Linux box and caused the problem. I started to get swap errors with error messages about system drive out of space. &nbsp;This shouldn't be a problem since there's only 6gigs out of 90+gigs of space on the thing. &nbsp;I also noticed that if I ran it a few times, I got different numbers in the error message: &nbsp;could not write to output file (X != 97).</P><P>So while the error message wasn't totally apparent, it made sense after I realized the space problem.</P><P>&gt;<BR>&gt;<BR>&gt;Patrick Hatcher<BR></P><P>&gt; <BR>&gt;<FONT SIZE=2><B>&quot;Jim C. Nasby&quot; &lt;jim(at)nasby(dot)net&gt;</B></FONT><BR>&gt;<FONT SIZE=2>06/30/2003 08:11 PM EST</FONT><BR>&gt;<BR>&gt; <FONT SIZE=2>To:</FONT> <FONT SIZE=2>Patrick Hatcher &lt;PHatcher(at)macys(dot)com&gt;</FONT><BR>&gt; <FONT SIZE=2>cc:</FONT> <FONT SIZE=2>pgsql-general(at)postgresql(dot)org</FONT><BR>&gt; <FONT SIZE=2>bcc:</FONT> <BR>&gt; <FONT SIZE=2>Subject:</FONT> <FONT SIZE=2>Re: [GENERAL] Pg_Dumpall error?</FONT><BR>&gt; <BR>&gt;<BR>&gt;</P><P>&gt;<FONT FACE="Courier">Forgive the stupid question, since I'm completely unfamiliar with the<BR>&gt;logging changes Tom is busy working on, but would it be worthwhile to<BR>&gt;have error messages/asserts include a function/filename where the assert<BR>&gt;failed? (I'm assuming this is an assert failure). If the assert code<BR>&gt;could be easily changed to add that info, it might be helpful to those<BR>&gt;not intimately familiar with the code.<BR>&gt;</FONT><BR>&gt;<FONT FACE="Courier">Just a thought.<BR>&gt;</FONT><BR>&gt;<FONT FACE="Courier">On Mon, Jun 30, 2003 at 03:03:52PM -0700, Patrick Hatcher wrote:<BR>&gt;&gt; I've done numerous dumps, but I've never seen this type of error before:<BR>&gt;&gt;<BR>&gt;&gt; pg_dumpall &gt; datamart.out<BR>&gt;&gt; pg_dump: [archiver] could not write to output file (36 != 97)<BR>&gt;&gt; pg_dumpall: pg_dump failed on bdc_oz, exiting<BR>&gt;&gt;<BR>&gt;&gt; Any ideas?<BR>&gt;&gt; I'm running Pg 7.3.2<BR>&gt;&gt;<BR>&gt;&gt; TIA<BR>&gt;&gt; Patrick Hatcher<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; ---------------------------(end of broadcast)---------------------------<BR>&gt;&gt; TIP 7: don't forget to increase your free space map settings<BR>&gt;&gt;<BR>&gt;</FONT><BR>&gt;<FONT FACE="Courier">--<BR>&gt;Jim C. Nasby, Database Consultant &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;jim(at)nasby(dot)net<BR>&gt;Member: Triangle Fraternity, Sports Car Club of America<BR>&gt;Give your computer some brain candy! www.distributed.net Team #1828<BR>&gt;</FONT><BR>&gt;<FONT FACE="Courier">Windows: &quot;Where do you want to go today?&quot;<BR>&gt;Linux: &quot;Where do you want to go tomorrow?&quot;<BR>&gt;FreeBSD: &quot;Are you guys coming, or what?&quot;</FONT></P>
>From pgsql-general-owner(at)postgresql(dot)org Tue Jul 1 02:13:04 2003
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.193])
by svr1.postgresql.org (Postfix) with ESMTP id 4B305310A80
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Tue, 1 Jul 2003 05:13:03 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024)
with ESMTP id 82041-02
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Tue, 1 Jul 2003 02:12:53 -0300 (ADT)
Received: from MANI (unknown [61.11.81.106])
by svr1.postgresql.org (Postfix) with ESMTP id 9133C310982
for <pgsql-general(at)postgresql(dot)org>; Tue, 1 Jul 2003 02:12:50 -0300 (ADT)
Received: from madhu (192.168.1.6)
by MANI with MERCUR Mailserver (v4.02.11 Mjk4NTQtNjI3Ny0xNzE2NQ=)
for <pgsql-general(at)postgresql(dot)org>; Tue, 1 Jul 2003 10:44:46 +0530
From: "Madhavi Daroor" <madhavi(at)zoniac(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: 2 different versions of postgres on the same system
Date: Tue, 1 Jul 2003 10:42:27 +0530
Message-ID: <NHBBKMLNGKEMDMCGAMFNAEJGCAAA(dot)madhavi(at)zoniac(dot)com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Spam-Status: No, hits=2.3 tagged_above=0.0 required=5.0 testsºYES_10,
MSGID_GOOD_EXCHANGE, RCVD_IN_DSBL, RCVD_IN_NJABL, RCVD_IN_OSIRUSOFT_COM,
RCVD_IN_RFCI
X-Spam-Level: **
X-Archive-Number: 200307/10
X-Sequence-Number: 44864

Hi all,
I have installed postgres 7.3 in my Red hat linux 7.2 system. I want to
also install postgres 7.2.3 in the same system. Is it possible?? Can
somebody please tell me how I can do this...ASAP!!!

Regards,
Madhavi

Attachment Content-Type Size
unknown_filename text/html 4.7 KB

Browse pgsql-general by date

  From Date Subject
Next Message Arguile 2003-07-01 05:21:14 Re: 2 different versions of postgres on the same system
Previous Message Richard Welty 2003-07-01 01:35:58 oracle->postgresql references