Re: [GENERAL] 9.1 to 9.2 requires a dump/reload?

2012-11-24 Thread Christian Hammers
Hello Can you remember where did you read that? There is no mention of GIST on http://www.postgresql.org/docs/9.2/static/upgrading.html and a database which uses GIST indexes *seems* to work just finde after upgrading with pg_upgrade. bye, -christian- Am Mon, 22 Oct 2012 15:02:13 -0700

Re: [GENERAL] 9.1 to 9.2 requires a dump/reload?

2012-11-24 Thread Bruce Momjian
On Sat, Nov 24, 2012 at 06:03:32PM +0100, Christian Hammers wrote: Hello Can you remember where did you read that? There is no mention of GIST on http://www.postgresql.org/docs/9.2/static/upgrading.html and a database which uses GIST indexes *seems* to work just finde after upgrading with

Re: [GENERAL] 9.1 to 9.2 requires a dump/reload?

2012-11-07 Thread Bruce Momjian
On Tue, Oct 23, 2012 at 09:41:20AM -0400, Nikolas Everett wrote: On Mon, Oct 22, 2012 at 6:17 PM, Alan Hodgson ahodg...@simkin.ca wrote: On Monday, October 22, 2012 05:55:07 PM Nikolas Everett wrote: I see that pg_upgrade is an option. Having never used how long should I

Re: [GENERAL] 9.1 to 9.2 requires a dump/reload?

2012-10-23 Thread Nikolas Everett
On Mon, Oct 22, 2012 at 6:17 PM, Alan Hodgson ahodg...@simkin.ca wrote: On Monday, October 22, 2012 05:55:07 PM Nikolas Everett wrote: I see that pg_upgrade is an option. Having never used how long should I expect pg_upgrade to take? Obviously we'll measure it in our environment, but

Re: [GENERAL] 9.1 to 9.2 requires a dump/reload?

2012-10-23 Thread Scott Marlowe
On Tue, Oct 23, 2012 at 7:41 AM, Nikolas Everett nik9...@gmail.com wrote: On Mon, Oct 22, 2012 at 6:17 PM, Alan Hodgson ahodg...@simkin.ca wrote: On Monday, October 22, 2012 05:55:07 PM Nikolas Everett wrote: I see that pg_upgrade is an option. Having never used how long should I expect

[GENERAL] 9.1 to 9.2 requires a dump/reload?

2012-10-22 Thread Nikolas Everett
I was just looking at http://www.postgresql.org/docs/devel/static/release-9-2.html and it mentioned that a dump/reload cycle was required to upgrade from a previous release. I just got done telling some of my coworkers that PG had been bitten by this enough times that they were done with it. Am

Re: [GENERAL] 9.1 to 9.2 requires a dump/reload?

2012-10-22 Thread Lonni J Friedman
pg_upgrade has worked fine for several releases. I believe that the only time when pg_upgrade isn't a viable option is for some types of GIST indices. On Mon, Oct 22, 2012 at 2:55 PM, Nikolas Everett nik9...@gmail.com wrote: I was just looking at

Re: [GENERAL] 9.1 to 9.2 requires a dump/reload?

2012-10-22 Thread Alan Hodgson
On Monday, October 22, 2012 05:55:07 PM Nikolas Everett wrote: I was just looking at http://www.postgresql.org/docs/devel/static/release-9-2.html and it mentioned that a dump/reload cycle was required to upgrade from a previous release. I just got done telling some of my coworkers that PG had