Thread: 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