Dblink upgrade from 8.4 to 9.1

From: Rueegg Alexander <ALR(at)bdal(dot)de>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Dblink upgrade from 8.4 to 9.1
Date: 2011-09-19 08:44:32
Message-ID: 59BC4792497BB345A9349A2B463CDAB20DB424F8@HBMAILBOX20.bdal.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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" on the database fails too! When deleting all dblink functions and the dblink type manually and executing "create extension if 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(at)bdal(dot)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 einen Brief oder ein Fax entsprechend best?tigt wird.

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

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

________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rueegg Alexander 2011-09-19 09:40:44 Re: Dblink upgrade from 8.4 to 9.1
Previous Message Thomas Kellerer 2011-09-19 06:38:59 Re: Indexes not allowed on (read-only) views: Why?