Skip site navigation (1) Skip section navigation (2)

Re: [pgadmin-support] Replication upgrade fails

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: "Chris St Denis" <chris(at)smartt(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgadmin-support] Replication upgrade fails
Date: 2008-06-16 11:33:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackerspgadmin-support
On Thu, Jun 12, 2008 at 10:40 PM, Chris St Denis <chris(at)smartt(dot)com> wrote:
> I upgraded slony on the servers from 1.2.13 to 1.2.14 and downloaded the
> 1.2.14 creation scripts to my client.
> I created the new empty cluster and did a "upgrade node" on the old cluster,
> selecting the new one from the box.
> I get "Column not found in pgSet: indname"
> After dismissing that error dialog I get a second one.
> 'Error: relation "sl_log_1_idx1" already exists.'

Apologies for the late reply. I cannot reproduce the error you quote
here, but I have found another nasty issue which I'd like to bounce
off the other hackers...

It seems that current versions of the slony scripts embed the cluster
schema name in some of the functions. This means that if we create a
dummy cluster called 'upgrade' on a node, and then upgrade a cluster
called 'pgbench', the pgbench cluster references functions directly in
the _upgrade schema. This works fine (unless something gets changed in
the _upgrade schema of course), but barfs horribly when upgrading a
cluster on a different node which doesn't have the _upgrade schema.

The obvious first-thought solution is to search 'n' replace the schema
name when we generate the upgrade script. It doesn't take more than a
minute or two to think of ways that this may easily break however. The
second option is to only allow an upgrade from a cluster with the same
name, but that makes it kinda awkward to do the upgrade.

Any other ideas? (Magnus, Guillaume, others?)

Dave Page
EnterpriseDB UK:

In response to

pgadmin-hackers by date

Next:From: svnDate: 2008-06-16 15:51:53
Subject: SVN Commit by hiroshi: r7375 - trunk/www/download
Previous:From: Dave PageDate: 2008-06-16 08:27:27
Subject: Re: Server Status window work

pgadmin-support by date

Next:From: Laurent ROCHEDate: 2008-06-16 12:36:27
Subject: For the PG experts
Previous:From: Guillaume LelargeDate: 2008-06-14 14:11:32
Subject: Re: Weird Popup Menus - pgAdmin 1.8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group