From: Janning Vygen <vygen@gmx.de>
To: val@webtribe.net
To: pgsql-sql@postgresql.org
Subject: Re: copy help
Date: Mon, 3 Mar 2003 11:29:16 +0100
Message-ID: <200303031029.h23ATHa03958@janning.planwerk6.local> (raw)
In-Reply-To: <20030303091602.475E818332@cheetah.webtribe.net>
References: <20030303091602.475E818332@cheetah.webtribe.net>
Am Montag, 3. März 2003 10:16 schrieb val@webtribe.net:
> I am trying to copy out about 50G of data.
>
> When I used copy table X to '/opt/x.csv' using delimiters ','
> with null as '';
> and x.csv reached a size of 2G, I got the error message that the
> file was too big.
>
> How can I get around this without moving things out in smaller
> packages (more time-consuming)?
It's a matter of the underlaying operating system which doesnt allow
files bigger than 2G. You can send your output in a pipe and split it
on several files.
see 'man split' for details.
This kind of problem is described in the postgresql manual in the
backup section. Take a look at the manual too.
kind regards
janning
--
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf
fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de
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: vygen@gmx.de, val@webtribe.net
Subject: Re: copy help
In-Reply-To: <200303031029.h23ATHa03958@janning.planwerk6.local>
* 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