Re: Errors on restoring a 7.1.2 dump to 7.3.3

From: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stuart Woodward <woodward(at)garage(dot)co(dot)jp>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Errors on restoring a 7.1.2 dump to 7.3.3
Date: 2003-09-04 06:15:15
Message-ID: 266C29FE-DE9F-11D7-B534-000393C78AC0@visualdistortion.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Wednesday, September 3, 2003, at 10:47 PM, Tom Lane wrote:

> Stuart Woodward <woodward(at)garage(dot)co(dot)jp> writes:
>> On restoring a plain-text SQL script file dumped from a version 7.1.2
>> database to 7.3.3 I got the following errors.
>
>> ERROR: copy: line 67568, Temporary log file is full
>> ..and many
>> ERROR: Default table space is full

We recently ran into a nasty Oracle bug at work where the default
tablespace was full. It just died, and was unrecoverable without
restoring from backup.

> You're joking, no? Neither string appears anywhere in the 7.3 sources,
> nor any other PG release that I know of.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
> joining column's datatypes do not match

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-09-04 06:57:00 Re: Powergres (was Re: Errors on restoring a 7.1.2 dump to 7.3.3)
Previous Message Jeffrey Melloy 2003-09-04 06:12:43 Re: order by, but eliminating dupes