Re: [GENERAL] Improve dump and restore time

2008-10-13 Thread Greg Smith
On Fri, 10 Oct 2008, Pascal Cohen wrote: Are there best practices to reduce the migration time ? There's a number of resources in this area listed at http://wiki.postgresql.org/wiki/Bulk_Loading_and_Restores I wanted to have an expectation of the migration duration and performed it on a le

Re: [GENERAL] Improve dump and restore time

2008-10-10 Thread Guillaume Lelarge
Hi, Pascal Cohen a écrit : > I am studying how to migrate our Production Database which is running > under PG 8.2 and we would like to move to PG 8.3 > I have read that the only safe solution is to perform a dump and restore. > Our DB is around 6GB large. > I wanted to have an expectation of the m

Re: [GENERAL] Improve dump and restore time

2008-10-10 Thread Pascal Cohen
Betreff: [Spam] [GENERAL] Improve dump and restore time Hello, I am studying how to migrate our Production Database which is running under PG 8.2 and we would like to move to PG 8.3 I have read that the only safe solution is to perform a dump and restore. Our DB is around 6GB large. I wanted to have an

[GENERAL] Improve dump and restore time

2008-10-10 Thread Pascal Cohen
Hello, I am studying how to migrate our Production Database which is running under PG 8.2 and we would like to move to PG 8.3 I have read that the only safe solution is to perform a dump and restore. Our DB is around 6GB large. I wanted to have an expectation of the migration duration and perfor