pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomasz Myrta <jasiek@klaster.net>
To: Rudi Starcevic <rudi@oasis.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump problem
Date: Wed, 01 Jan 2003 12:34:49 +0100
Message-ID: <3E12D259.8020300@klaster.net> (raw)
In-Reply-To: <3E264CE2.70306@oasis.net.au>
References: <3E264CE2.70306@oasis.net.au>

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





view thread (6+ messages)  latest in thread

Message-ID: <3E12D259.8020300@klaster.net>
Permalink:  ../3E12D259.8020300@klaster.net/
Also on:    postgresql.org/message-id/3E12D259.8020300@klaster.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jasiek@klaster.net, rudi@oasis.net.au
  Subject: Re: pg_dump problem
  In-Reply-To: <3E12D259.8020300@klaster.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox