Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1B22E2E3E65 for ; Sat, 15 Dec 2007 14:16:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27253-02 for ; Sat, 15 Dec 2007 14:16:15 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id 5748F2E304C for ; Sat, 15 Dec 2007 14:16:15 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so2271404waf.5 for ; Sat, 15 Dec 2007 10:16:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=gT6Lp2gkImc//8b17mHQHW/ye/jz7ETha3uB+GstePk=; b=N39Z0mz71OPq3/xBbJxidncIn+1y+Y4VOqSCM4Aa424LF2SjzFu0wC6d3VsZQhXDNu7Alky1lW+zOfT2yddAIwxjCCz5j4XX6ZgRBahXnWbAtxRv/9H1Tdd859VSSXvHM0RtcF7x0q6uk6hwqw82B+lIPQ5BiPLr3BbxKrfCtWU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Xb9brT9RD8FGf6Ee+aGrRfYfcXpMHkffsQRWPwh9jBu7kSKY4gWedWAt1mlXDtWehD49gH4j+U2cHxCZBCB5j9nRNPuNlDcds//3xXqddo61E8UdHde+d4SAOV+bNFmDuHfQp0+5n5au1Y8Xu0DrRvsIfqOH1GMVUEZD/XkZC5Y= Received: by 10.115.54.1 with SMTP id g1mr967886wak.132.1197742574031; Sat, 15 Dec 2007 10:16:14 -0800 (PST) Received: by 10.114.131.4 with HTTP; Sat, 15 Dec 2007 10:16:14 -0800 (PST) Message-ID: Date: Sat, 15 Dec 2007 12:16:14 -0600 From: "Scott Marlowe" To: A.Burbello Subject: Re: Dump database more than 1 flat file Cc: pgsql-admin@postgresql.org In-Reply-To: <470265.440.qm@web36215.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <470265.440.qm@web36215.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/119 X-Sequence-Number: 27636 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?