Обсуждение: copy help

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)?

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