pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRestoration of datas
2+ messages / 2 participants
[nested] [flat]
* Restoration of datas
@ 2008-08-08 07:25 dforums <dforums@vieonet.com>
2008-08-08 07:56 ` Re: Restoration of datas Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 2+ messages in thread
From: dforums @ 2008-08-08 07:25 UTC (permalink / raw)
To: pgsql-performance
Hello
Regarding the advice from all, and the performance of postgresql 8.3.3
I'm trying to change the server and to upgrade to 8.3.3
I install postgresql 8.3.3 on a new server for testing. All well!!!
And I run a \i mybackup.sql since yesterday 7pm. This morning the datas
are not insert yet.
COuld you advice me on which restoration method is the faster. To
upgrade from postgresql 8.1.11 to 8.3.3.
Regards
David
--
<http://www.1st-affiliation.fr;
*David Bigand
*Président Directeur Générale*
*51 chemin des moulins
73000 CHAMBERY - FRANCE
Web : htttp://www.1st-affiliation.fr
Email : david@1st-affiliation.com
Tel. : +33 479 696 685
Mob. : +33 666 583 836
Skype : firstaffiliation_support
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Restoration of datas
2008-08-08 07:25 Restoration of datas dforums <dforums@vieonet.com>
@ 2008-08-08 07:56 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2008-08-08 07:56 UTC (permalink / raw)
To: dforums <dforums@vieonet.com>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-08-08 07:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-08 07:25 Restoration of datas dforums <dforums@vieonet.com>
2008-08-08 07:56 ` Richard Huxton <dev@archonet.com>
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