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, exitingAny ideas?
I'm running Pg 7.3.2TIA
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 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@nasby.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@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><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@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></P>
From pgsql-general-owner@postgresql.org Tue Jul 1 02:13:04 2003
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
by svr1.postgresql.org (Postfix) with ESMTP id 4B305310A80
for <pgsql-general-postgresql.org@localhost.postgresql.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.org@localhost.postgresql.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@postgresql.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@postgresql.org>; Tue, 1 Jul 2003 10:44:46 +0530
From: "Madhavi Daroor" <madhavi@zoniac.com>
To: <pgsql-general@postgresql.org>
Subject: 2 different versions of postgres on the same system
Date: Tue, 1 Jul 2003 10:42:27 +0530
Message-ID: <NHBBKMLNGKEMDMCGAMFNAEJGCAAA.madhavi@zoniac.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=BAYES_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
Import Notes
Resolved by subject fallback
"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?
--
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