From: Decibel! <decibel@decibel.org>
To: ??????? ????????? ???????? <a.kazorez@investcapitalbank.ru>
Cc: pgsql-admin@postgresql.org
Subject: Re: Help
Date: Fri, 3 Aug 2007 19:19:15 -0500
Message-ID: <20070804001915.GC25704@nasby.net> (raw)
In-Reply-To: <49445CCB0D89C8449A88680B4BFF53771E13E3@beta.icb.local>
References: <49445CCB0D89C8449A88680B4BFF53771E13E3@beta.icb.local>
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 'does not want' to be loaded as plain text, and it requires choosing another data format. After this I made a backup with '-Ft'. But we can not simply put 'tar' through 'iconv' , so I unarchived it and made a 'find ./ -exec iconv'. Well, after all this I could not put it all back together so that 'pg_restore' would not find it incorrect. I had to make a 'ls | cat | psql databasename'. After 15 hours of work nothing changed! :)
Why not? Plain text should still work fine. I've seen it done on 300G
databases.
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: decibel@decibel.org, a.kazorez@investcapitalbank.ru
Subject: Re: Help
In-Reply-To: <20070804001915.GC25704@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox