Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id CCCDE4766F7
	for <pgsql-sql@postgresql.org>; Thu, 16 Jan 2003 06:34:21 -0500 (EST)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id CC28947674D
	for <pgsql-sql@postgresql.org>; Thu, 16 Jan 2003 06:34:03 -0500 (EST)
Received: from klaster.net (pc21.krakow.cvx.ppp.tpnet.pl [213.76.38.21])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 4B7242B848; Thu, 16 Jan 2003 12:30:51 +0100 (CET)
Message-ID: <3E12D259.8020300@klaster.net>
Date: Wed, 01 Jan 2003 12:34:49 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US;
	rv:1.2b) Gecko/20021016
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Rudi Starcevic <rudi@oasis.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump problem
References: <3E264CE2.70306@oasis.net.au>
In-Reply-To: <3E264CE2.70306@oasis.net.au>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/258
X-Sequence-Number: 11123

Rudi Starcevic wrote:

>Hi,
>
>After doing a pg_dump on a database I'm unable to access the file.
>
>My command is simply 'mv' ::
>
>mv camper.dump20020116 camper_bak/
>
>The error I get is ::
>
>mv: camper.dump20020116: Value too large for defined data type
>
>Strange. It seems to be saying the file I created is too large to handle.
>Do you know where I've gone wrong ?
>I just want to dump one of my databases, move it to a back up dir. then 
>make changes to the running database.

It looks like you have not a postgres, but filesystem problem. How big is this file?
Anyway pg_dump can save filedump in gzip format, which is better for further backuping.

Regards,
Tomasz Myrta