From: Khangelani Gama <kgama@argility.com>
References: <bf801eb082936b7671c4f7dfb26beec3@mail.gmail.com>
 <1407159008.1433.YahooMailNeo@web122302.mail.ne1.yahoo.com>
In-Reply-To: <1407159008.1433.YahooMailNeo@web122302.mail.ne1.yahoo.com>
MIME-Version: 1.0
Thread-Index: AQLAo3AD0SI8NySoocndshO8R1ykkQFN/yMxmdRPuqA=
Date: Mon, 4 Aug 2014 18:48:44 +0200
Message-ID: <e2a3414f118ca2958923c69c0abecc45@mail.gmail.com>
Subject: Re: upgrading postgres 7.3.4 to 9.1.9
To: Kevin Grittner <kgrittn@ymail.com>, pgsql-admin@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

-----Original Message-----
From: Kevin Grittner [mailto:kgrittn@ymail.com]
Sent: 04 August 2014 03:30 PM
To: Khangelani Gama; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] upgrading postgres 7.3.4 to 9.1.9

Khangelani Gama <kgama@argility.com> wrote:

> this one instance is still on postgres 7.
>
> I dumped postgres 7 database using pg_dump =E2=80=93Fc on postgres 7 bina=
ries
> and then attempted pg_restore =E2=80=93Fc (using postgres9.1.9
> binaries)

The recommended approach is to perform the dump with software from the newer
version.

> which threw out the following errors.

> ERROR:  language "plpgsql" already exists
> DETAIL:  Proceeding with relation creation anyway.

I'm not sure you'll get this if you use the 9.1 pg_dump.  In any event, I
think it could be safely ignored if you do so.

> ERROR:  could not access file "$libdir/plperl": No such file or
> directory
> ERROR:  function public.plperl_call_handler() does not exist
> ERROR:  could not access file "$libdir/plperl": No such file or
> directory
> ERROR:  language "plperlu" does not exist

I would use CREATE EXTENSION for plperlu on the 9.1 database before
attempting to restore.

> Because of the above errors I tried the following
>
> /usr/local/pgsql9/bin/createlang -p59999 plperl template1
>
> createlang: language installation failed: ERROR:  could not open
> extension control file
> "/usr/local/pgsql9/share/extension/plperl.control": No such file or
> directory


Thanks Kevin, in psql I keep getting the following errors: I saw what it is
explained in
http://stackoverflow.com/questions/12136033/install-pl-perl-in-postgresql
But I am not sure if this installation command "yum install perl-devel" will
work without affecting other special setups.


template1=3D#  CREATE EXTENSION plperl;
ERROR:  could not open extension control file
"/usr/local/pgsql9/share/extension/plperl.control": No such file or
directory
template1=3D#  CREATE EXTENSION plperlu;
ERROR:  could not open extension control file
"/usr/local/pgsql9/share/extension/plperlu.control": No such file or
directory


http://stackoverflow.com/questions/12136033/install-pl-perl-in-postgresql


CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. Any =
review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intended=
 addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries=
 distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other than =
strictly for business purposes.
=0D


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin