Re: Best Current Pratice Postgres upgrade 6.5-->7.2

2003-11-25 Thread Oliver Elphick
On Thu, 2003-11-20 at 16:23, Monique Y. Herman wrote: > On Thu, 20 Nov 2003 at 02:50 GMT, Henry Hollenberg penned: > > Hello, > > > > I have a database running on potato using postgres 6.5 that I'd like > > to upgrade to Woody running postgres 7.2. ... > I believe the install notes say, somewhere,

Re: Best Current Pratice Postgres upgrade 6.5-->7.2

2003-11-20 Thread Monique Y. Herman
On Thu, 20 Nov 2003 at 02:50 GMT, Henry Hollenberg penned: > Hello, > > I have a database running on potato using postgres 6.5 that I'd like > to upgrade to Woody running postgres 7.2. > > The docs seem to imply that upgrading with this big a jump from 6.5 to > 7.2 is dangerous.even if I do i

Re: Best Current Pratice Postgres upgrade 6.5-->7.2

2003-11-20 Thread John M Flinchbaugh
On Wed, Nov 19, 2003 at 06:50:19PM -0800, Henry Hollenberg wrote: > The docs seem to imply that upgrading with this big a jump from > 6.5 to 7.2 is dangerous.even if I do it by hand like so: > > pg_dump mydatabase > dump.mydatabase > destroydb mydatabase > upgrade the database system to 7.2 >

Best Current Pratice Postgres upgrade 6.5-->7.2

2003-11-19 Thread Henry Hollenberg
Hello, I have a database running on potato using postgres 6.5 that I'd like to upgrade to Woody running postgres 7.2. The docs seem to imply that upgrading with this big a jump from 6.5 to 7.2 is dangerous.even if I do it by hand like so: pg_dump mydatabase > dump.mydatabase destroydb mydata