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. 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. This shouldn't be a problem 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 got different numbers in the error message: 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>><BR>><BR>>Patrick Hatcher<BR></P><P>> <BR>><FONT SIZE=2><B>"Jim C. Nasby" <jim(at)nasby(dot)net></B></FONT><BR>><FONT SIZE=2>06/30/2003 08:11 PM EST</FONT><BR>><BR>> <FONT SIZE=2>To:</FONT> <FONT SIZE=2>Patrick Hatcher <PHatcher(at)macys(dot)com></FONT><BR>> <FONT SIZE=2>cc:</FONT> <FONT SIZE=2>pgsql-general(at)postgresql(dot)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><P>><FONT FACE="Courier">Forgive the stupid question, since I'm completely unfamiliar with the<BR>>logging changes Tom is busy working on, but would it be worthwhile to<BR>>have error messages/asserts include a function/filename where the assert<BR>>failed? (I'm assuming this is an assert failure). If the assert code<BR>>could be 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 seen this 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>>> Patrick Hatcher<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(at)nasby(dot)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></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 |
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 |