Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5A08764FD2F for ; Fri, 8 Aug 2008 04:42:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 40451-01 for ; Fri, 8 Aug 2008 04:41:52 -0300 (ADT) X-Greylist: delayed 00:06:41.197688 by SQLgrey-1.7.6 Received: from 42.mail-out.ovh.net (42.mail-out.ovh.net [213.251.189.42]) by postgresql.org (Postfix) with SMTP id 151E464FCDE for ; Fri, 8 Aug 2008 04:41:53 -0300 (ADT) Received: (qmail 1781 invoked by uid 503); 8 Aug 2008 07:34:53 -0000 Received: from gw2.ovh.net (HELO mail142.ha.ovh.net) (213.251.189.202) by 42.mail-out.ovh.net with SMTP; 8 Aug 2008 07:34:53 -0000 Received: from b0.ovh.net (HELO queue-out) (213.186.33.50) by b0.ovh.net with SMTP; 8 Aug 2008 07:35:18 -0000 Received: from ita73-1-82-239-31-94.fbx.proxad.net (HELO localhost.localdomain) (dforums@vieonet.com@82.239.31.94) by ns0.ovh.net with SMTP; 8 Aug 2008 07:35:17 -0000 Message-ID: <489BF4DE.4060504@vieonet.com> Date: Fri, 08 Aug 2008 09:25:18 +0200 From: dforums User-Agent: Thunderbird 2.0.0.14 (X11/20080501) MIME-Version: 1.0 To: Pgsql performance Subject: Restoration of datas Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Ovh-Tracer-Id: 17813143902418552625 X-Ovh-Remote: 82.239.31.94 (ita73-1-82-239-31-94.fbx.proxad.net) X-Ovh-Local: 213.186.33.20 (ns0.ovh.net) X-Spam-Check: DONE|H 0.5/N X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/66 X-Sequence-Number: 30947 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 -- *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