Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C63232E3129 for ; Mon, 17 Dec 2007 19:08:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 98048-03 for ; Mon, 17 Dec 2007 19:08:30 -0400 (AST) Received: from mout.perfora.net (mout.perfora.net [74.208.4.196]) by postgresql.org (Postfix) with ESMTP id A33ED2E3128 for ; Mon, 17 Dec 2007 19:08:44 -0400 (AST) Received: from [172.16.255.106] (duck.3times25.net [66.23.211.34]) by mrelay.perfora.net (node=mrus0) with ESMTP (Nemesis) id 0MKp8S-1J4P4k0duX-0006tl; Mon, 17 Dec 2007 18:08:43 -0500 Message-ID: <47670179.20201@serioustechnology.com> Date: Mon, 17 Dec 2007 18:08:41 -0500 From: Geoffrey User-Agent: Thunderbird 1.5.0.8 (X11/20061025) MIME-Version: 1.0 To: Postgres Adm List Subject: Re: Dump database more than 1 flat file References: <866220.35252.qm@web36213.mail.mud.yahoo.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX1/qSWhmPBzaGbsah5btfjksYqkAAgfHAfkHWil ZM+WhKGqOuCftiSNQrWjv2GwPXoVT6rquwTHaKYpXledLALMlM pcHusZS7QPaSsiwF18uwepoy+2+mEVl X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/150 X-Sequence-Number: 27667 Scott Marlowe wrote: > On Dec 17, 2007 2:06 PM, A.Burbello wrote: >> 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 > > http://gnuwin32.sourceforge.net/packages/coreutils.htm > > for now. I used these back in the day (NT4.0 SP4 or so) and they > worked a charm back then. Heck, even ln worked ( in a manner of > speaking ) back then. There's also Uwin from AT&T: http://www.research.att.com/sw/tools/uwin list of available commands and man pages: http://www.research.att.com/~gsf/man/man1/ -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin