From: | Alexander Rüegg <alr(at)bdal(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Upgrade extension from 8.4 to 9.1 |
Date: | 2011-09-21 06:41:48 |
Message-ID: | j5c0vc$27vo$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
sorry for posting this again, but my earlier questions did not appear in
the news server just on the webpage.
I am migrating databases from 8.4 to 9.1 using traditional backup and
restore. After restore to a clean database everything seems to be ok.
The only thing is that there are no extensions for my prior installed
modules. Do I really have to install extensions with "create extension
XXXXX from unpackaged"?
When I try to create the extension for "dblink" I get the following error:
ERROR: function dblink_get_notify() does not exist SQL Status:42883
In 8.4 I installed the module with the appropriate sql script in
share/contrib.
Now I ended up with uninstalling the module with the uninstall-script in
share/contrib and then creating the extension without "unpackaged". But
as we use PG in a product with a NSIS installer this makes the world
unnecessary complicated.
Thanks for your help in advance
Alex
From | Date | Subject | |
---|---|---|---|
Next Message | MirrorX | 2011-09-21 07:59:40 | Re: upgrade postgres to 8.4.8, centos 5.3 |
Previous Message | Scott Marlowe | 2011-09-21 03:22:03 | Re: Replication between 64/32bit systems? |