| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | dforums <dforums(at)vieonet(dot)com> |
| Cc: | Pgsql performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Restoration of datas |
| Date: | 2008-08-08 07:56:50 |
| Message-ID: | 489BFC42.8040603@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik | 2008-08-08 14:23:55 | Filesystem benchmarking for pg 8.3.3 server |
| Previous Message | dforums | 2008-08-08 07:25:18 | Restoration of datas |