X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F3134474E61 for ; Mon, 3 Mar 2003 05:29:17 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 13055-06 for ; Mon, 3 Mar 2003 05:29:16 -0500 (EST) Received: from issv0170.isis.de (issv0170.isis.de [195.158.131.222]) by postgresql.org (Postfix) with SMTP id 1C26B474E42 for ; Mon, 3 Mar 2003 05:29:16 -0500 (EST) Received: (qmail 15980 invoked by uid 1010); 3 Mar 2003 10:29:16 -0000 Received: from unknown (HELO janning.planwerk6.local) ([213.128.124.20]) (envelope-sender ) by mail.isis.de (qmail-ldap-1.03) with SMTP for ; 3 Mar 2003 10:29:16 -0000 Received: from there (localhost [127.0.0.1]) by janning.planwerk6.local (8.11.6/8.11.6/SuSE Linux 0.5) with SMTP id h23ATHa03958; Mon, 3 Mar 2003 11:29:17 +0100 Message-Id: <200303031029.h23ATHa03958@janning.planwerk6.local> Content-Type: text/plain; charset="iso-8859-1" From: Janning Vygen Organization: Planwerk 6 /websolutions To: val@webtribe.net, pgsql-sql@postgresql.org Subject: Re: copy help Date: Mon, 3 Mar 2003 11:29:16 +0100 X-Mailer: KMail [version 1.3.1] References: <20030303091602.475E818332@cheetah.webtribe.net> In-Reply-To: <20030303091602.475E818332@cheetah.webtribe.net> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/61 X-Sequence-Number: 12101 Am Montag, 3. M=E4rz 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=20 files bigger than 2G. You can send your output in a pipe and split it=20 on several files. see 'man split' for details.=20 This kind of problem is described in the postgresql manual in the=20 backup section. Take a look at the manual too. kind regards janning --=20 Planwerk 6 /websolutions Herzogstra=DFe 86 40215 D=FCsseldorf fon 0211-6015919 fax 0211-6015917 http://www.planwerk6.de