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