pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcopy help
2+ messages / 2 participants
[nested] [flat]
* copy help
@ 2003-03-03 09:16 val@webtribe.net
0 siblings, 1 reply; 2+ messages in thread
From: val@webtribe.net @ 2003-03-03 09:16 UTC (permalink / raw)
To: pgsql-sql
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)?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: copy help
@ 2003-03-03 10:29 Janning Vygen <vygen@gmx.de>
parent: val@webtribe.net
0 siblings, 0 replies; 2+ messages in thread
From: Janning Vygen @ 2003-03-03 10:29 UTC (permalink / raw)
To: val@webtribe.net; pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-03-03 10:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-03 09:16 copy help val@webtribe.net
2003-03-03 10:29 ` Janning Vygen <vygen@gmx.de>
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