Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E30019FB642 for ; Fri, 3 Aug 2007 21:19:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 34590-01 for ; Fri, 3 Aug 2007 21:19:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id D75FA9FB570 for ; Fri, 3 Aug 2007 21:19:18 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 8857C56453; Fri, 3 Aug 2007 19:19:17 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Fri, 3 Aug 2007 19:19:15 -0500 Date: Fri, 3 Aug 2007 19:19:15 -0500 From: Decibel! To: ??????? ????????? ???????? Cc: pgsql-admin@postgresql.org Subject: Re: Help Message-ID: <20070804001915.GC25704@nasby.net> References: <49445CCB0D89C8449A88680B4BFF53771E13E3@beta.icb.local> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="/qNnUp0NPtZJWkzn" Content-Disposition: inline In-Reply-To: <49445CCB0D89C8449A88680B4BFF53771E13E3@beta.icb.local> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070804:a.kazorez@investcapitalbank.ru::2PIN295ogi9HWmn3:0000000 000000000000000000000000477p X-Hashcash: 1:20:070804:pgsql-admin@postgresql.org::G5J/Kh1eGAbS2DZb:00000000000 0000000000000000000000000zR7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/27 X-Sequence-Number: 26358 --/qNnUp0NPtZJWkzn Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Aug 03, 2007 at 06:57:29PM +0600, ??????? ????????? ???????? wrote: > This quotation deals with receiving an inserts pack as 'plain text'. Well= , well, but here we come to another problem: if a database is bulky, it 'do= es not want' to be loaded as plain text, and it requires choosing another d= ata format. After this I made a backup with '-Ft'. But we can not simply pu= t 'tar' through 'iconv' , so I unarchived it and made a 'find ./ -exec icon= v'. Well, after all this I could not put it all back together so that 'pg_r= estore' would not find it incorrect. I had to make a 'ls | cat | psql datab= asename'. After 15 hours of work nothing changed! :)=20 Why not? Plain text should still work fine. I've seen it done on 300G databases. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --/qNnUp0NPtZJWkzn Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFGs8YDdO30qud8SkgRAspWAJ90HkD/YHalFQ/0i5VuPrILpufJqQCgp1Iz Gfqpwr7XtQ2d2dPy2caKfwY= =4jM9 -----END PGP SIGNATURE----- --/qNnUp0NPtZJWkzn--