Message-ID: <489BFC42.8040603@archonet.com>
Date: Fri, 08 Aug 2008 08:56:50 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.16 (X11/20080707)
MIME-Version: 1.0
To: dforums <dforums@vieonet.com>
CC: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Restoration of datas
References: <489BF4DE.4060504@vieonet.com>
In-Reply-To: <489BF4DE.4060504@vieonet.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

dforums wrote:
> COuld you advice me on which restoration method is the faster. To 
> upgrade from postgresql 8.1.11 to 8.3.3.

Using the pg_dump from your 8.3 package, dump the database using -Fc to 
get a nicely compressed dump. Then use pg_restore to restore it. If you 
add a --verbose flag then you will be able to track it.

You might want to set fsync=off while doing the restore. This is safe 
since if the machine crashes during restore you just start again. Oh, 
and increase work_mem too - there's only going to be one process.

What will take the most time is the creating of indexes etc.

It will take a long time to do a full restore though - you've got 64GB 
of data and slow disks.

-- 
   Richard Huxton
   Archonet Ltd