Dblink upgrade from 8.4 to 9.1 - Mailing list pgsql-general

From Rueegg Alexander
Subject Dblink upgrade from 8.4 to 9.1
Date
Msg-id 59BC4792497BB345A9349A2B463CDAB20DB424F8@HBMAILBOX20.bdal.de
Whole thread Raw
Responses Re: Dblink upgrade from 8.4 to 9.1
List pgsql-general
Hi all!

I am upgrading databases from 8.4 to 9.1 using backup/restore. Whilst the restore procedure migrate the module
"uuid-ossp"automatically, the module "dblink" is not. Executing "create extension if not exists dblink from unpackaged"
onthe database fails too! When deleting all dblink functions and the dblink type manually and executing "create
extensionif not exists dblink" the module is installed correctly. 
What is going wrong here or did I miss something?

Best regards
Alex

--
Alexander Rueegg
Software Development
BioCompass
Bruker Daltonik GmbH (Bremen)

Phone: +49 421 2205 446
Fax: +49 421 2205 305
E-Mail: alr@bdal.de




-----------------------------
Bruker Daltonik GmbH

Fahrenheitstrasse 4             Gesch?ftsf?hrer                         Sitz der Gesellschaft
28359 Bremen                    Frank Laukien, Ph. D.           Bremen
Germany                                 Gerd H?lso
                                                Sebastian Meyer-Plath           Handelsregister
Permoserstrasse 15              Stefan Ruge                                     Amtsgericht Bremen
04318 Leipzig                   Ian Sanders, Ph. D.                     HRB 8150
Germany                                 Dr. Michael Schubert            www.bdal.de


Haftungsausschluss: Die Bruker Daltonik GmbH ist nicht verantwortlich f?r die ordnungsgem??e, vollst?ndige und
verz?gerungsfreie?bertragung der Nachricht. Der Inhalt der E-Mail ist nur rechtsverbindlich, wenn er unsererseits durch
einenBrief oder ein Fax entsprechend best?tigt wird. 

Exclusion from liability: Any liability of Bruker Daltonik GmbH referring to the correct, complete and immediate
transmissionof the message shall be excluded. The content of the e-mail including its attachments is only legally
bindingif confirmed by Bruker Daltonik GmbH by letter or fax. 



-----------------------------

________________________________


pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Indexes not allowed on (read-only) views: Why?
Next
From: Rueegg Alexander
Date:
Subject: Re: Dblink upgrade from 8.4 to 9.1