Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D12DF2E30CA for ; Mon, 17 Dec 2007 16:06:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 67333-04 for ; Mon, 17 Dec 2007 16:06:56 -0400 (AST) Received: from web36213.mail.mud.yahoo.com (web36213.mail.mud.yahoo.com [209.191.68.239]) by postgresql.org (Postfix) with SMTP id A46B12E30A0 for ; Mon, 17 Dec 2007 16:06:55 -0400 (AST) Received: (qmail 36167 invoked by uid 60001); 17 Dec 2007 20:06:53 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=SZDvWxxsMkZZsD8zSziaOqqFJmsbf2D2NGmEcU3CdlAMLUdjyr/hEZm+ZtfgpzikcyHBVfCP0lQR9RQkeg4JKxhFEhJNmG8MEy5V2U/6ZtrX4LD9cx87C7H2cmIpxqmTlPNjQoiIP39U2NxBNRRocB0nVHlUCUzZGazSvRF9Hts=; X-YMail-OSG: _SB5Ch0VM1mTEaXsl.exBmglaFb15jZDMPWBUsSm3.5Vbw_y9S8k6AszSO6e0Xf_m.ZatqcVULszBTLI6YQEWmsIjlcRVmSOa_LPGH50su9K9ybJn.U17X9vIf6JUw-- Received: from [200.140.200.133] by web36213.mail.mud.yahoo.com via HTTP; Mon, 17 Dec 2007 17:06:53 ART Date: Mon, 17 Dec 2007 17:06:53 -0300 (ART) From: "A.Burbello" Subject: Re: Dump database more than 1 flat file To: Postgres Adm List In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <866220.35252.qm@web36213.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/145 X-Sequence-Number: 27662 I consider this way a good practice to transport the files. This is because I have table that has more than 30GB. But if the OS was windows, couldn't split the files because postgres doesn't has this feature! Could be a good option if postgres had native. Weel, I will try this: eg: $ pg_dump postgres -U postgres -f split.txt | split --bytes=10m Thank you. --- Scott Marlowe escreveu: > On Dec 15, 2007 11:42 AM, A.Burbello > wrote: > > Hi people, > > > > How can I export (dump) database more than 1 file? > > I have great table and can't split. > > Like Oracle, just set the parameter filesize and > the > > files name, and dump in several files. > > You could pipe the output of pg_dump to split, or > split it after it's > been created. > > But is there a reason for doing this or is it just > some practice you're into? > Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/