Restore Question

Поиск
Список
Период
Сортировка
Искать

Restore Question

От:
Chris Ruprecht <chrup999@yahoo.com>
Дата:
Hi all,

I'm upgrading from 7.1.3 to 7.2. Right now, I'm busy doing backups, 
so I have a little time to think.
I'm thinking of changing some of the int8 fields into int4 fields, 
since this would save about 4 bytes/record and with 25 Million 
records, this is 100 MB just in the data per field, but the int8 
values are also used in a few indexes, so I might save maybe a GB or 
so.
The problem is, that the file which contains the pg_dump data is 2.8 
GB in size and I don't want to tackle that with an editor. (Schema 
info lives in the front of the file, then follows the data, then 
follow the indexes).

In the old days, before editors where written is such a way that they 
suck all the data into their buffer all at once, we had stuff which 
only loaded so-and-so many KB at a time. Is there still something 
like that out there which is safe to use with a Postgres dump file?

Best regards,
Chris
-- 
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: Restore Question

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Chris Ruprecht  writes:
> The problem is, that the file which contains the pg_dump data is 2.8 
> GB in size and I don't want to tackle that with an editor.

It may be too late if you already started the dump, but --- you could
easily avoid that issue by dumping schema and data separately.

Otherwise, consider using "sed" or some such to make the substitutions.

			regards, tom lane

Re: Restore Question

От:
"Chad R. Larson" <clarson@eldocomp.com>
Дата:
At 02:36 PM 2/8/2002 , Chris Ruprecht wrote:
>In the old days, before editors where written is such a way that they suck 
>all the data into their buffer all at once, we had stuff which only loaded 
>so-and-so many KB at a time. Is there still something like that out there 
>which is safe to use with a Postgres dump file?

I'd use sed (the Stream EDitor).


         -crl
--
Chad R. Larson (CRL22)    chad@eldocomp.com
   Eldorado Computing, Inc.   602-604-3100
      5353 North 16th Street, Suite 400
        Phoenix, Arizona  85016-3228

FAQ