Re: [ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

On Fri, Oct 19, 2012 at 02:44:05PM -0700, Lonni J Friedman wrote: > Greetings, > I'm in the process of planning for a production upgrade from 9.1.6 to > 9.2.x (all Linux-x86-64). In my staging environment (which has the > same versions), I kicked off pg_upgrade about 5 hours ago, and its > still n

Re: [ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

On Wed, Nov 7, 2012 at 10:42 AM, Bruce Momjian wrote: > On Fri, Oct 19, 2012 at 02:44:05PM -0700, Lonni J Friedman wrote: >> Greetings, >> I'm in the process of planning for a production upgrade from 9.1.6 to >> 9.2.x (all Linux-x86-64). In my staging environment (which has the >> same versions),

[ADMIN] bumping all sequence ids in a schema

I would like to bump all sequences in a schema by a specified increment. Is there a stored proc or some method that is recommended? Currently I have sql that generates scripts to do this, but it seems to be an inelegant approach and before I rework it from the ground up I want to see if anyone has

Re: [ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

On Wed, Nov 7, 2012 at 10:44:12AM -0800, Lonni J Friedman wrote: > On Wed, Nov 7, 2012 at 10:42 AM, Bruce Momjian wrote: > > On Fri, Oct 19, 2012 at 02:44:05PM -0700, Lonni J Friedman wrote: > >> Greetings, > >> I'm in the process of planning for a production upgrade from 9.1.6 to > >> 9.2.x (all

Re: [ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

On Wed, Nov 7, 2012 at 12:59 PM, Bruce Momjian wrote: > On Wed, Nov 7, 2012 at 10:44:12AM -0800, Lonni J Friedman wrote: >> On Wed, Nov 7, 2012 at 10:42 AM, Bruce Momjian wrote: >> > On Fri, Oct 19, 2012 at 02:44:05PM -0700, Lonni J Friedman wrote: >> >> Greetings, >> >> I'm in the process of pl

Re: [ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

On Wed, Nov 7, 2012 at 01:06:19PM -0800, Lonni J Friedman wrote: > On Wed, Nov 7, 2012 at 12:59 PM, Bruce Momjian wrote: > > On Wed, Nov 7, 2012 at 10:44:12AM -0800, Lonni J Friedman wrote: > >> On Wed, Nov 7, 2012 at 10:42 AM, Bruce Momjian wrote: > >> > On Fri, Oct 19, 2012 at 02:44:05PM -070

Re: [ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

On Wed, Nov 7, 2012 at 1:07 PM, Bruce Momjian wrote: > On Wed, Nov 7, 2012 at 01:06:19PM -0800, Lonni J Friedman wrote: >> On Wed, Nov 7, 2012 at 12:59 PM, Bruce Momjian wrote: >> > On Wed, Nov 7, 2012 at 10:44:12AM -0800, Lonni J Friedman wrote: >> >> On Wed, Nov 7, 2012 at 10:42 AM, Bruce Mom

Re: [ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

On Wed, Nov 7, 2012 at 01:09:19PM -0800, Lonni J Friedman wrote: > On Wed, Nov 7, 2012 at 1:07 PM, Bruce Momjian wrote: > > On Wed, Nov 7, 2012 at 01:06:19PM -0800, Lonni J Friedman wrote: > >> On Wed, Nov 7, 2012 at 12:59 PM, Bruce Momjian wrote: > >> > On Wed, Nov 7, 2012 at 10:44:12AM -0800

Re: [ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

On Wed, Nov 7, 2012 at 1:15 PM, Bruce Momjian wrote: > On Wed, Nov 7, 2012 at 01:09:19PM -0800, Lonni J Friedman wrote: >> On Wed, Nov 7, 2012 at 1:07 PM, Bruce Momjian wrote: >> > On Wed, Nov 7, 2012 at 01:06:19PM -0800, Lonni J Friedman wrote: >> >> On Wed, Nov 7, 2012 at 12:59 PM, Bruce Momj

Re: [ADMIN] bumping all sequence ids in a schema

On 11/08/2012 04:42 AM, Mike Broers wrote: > I would like to bump all sequences in a schema by a specified > increment. Is there a stored proc or some method that is recommended? > Currently I have sql that generates scripts to do this, but it seems > to be an inelegant approach and before I rewor