Re: [PERFORM] Restoration of datas

2008-08-08 Thread Richard Huxton
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 y

[PERFORM] Restoration of datas

2008-08-08 Thread dforums
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.