From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
---|---|
To: | Tom Harkaway <tomh(at)hvpa(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Unable to createlang |
Date: | 2012-04-04 03:24:35 |
Message-ID: | CA+h6Ahhk7-36u9NDBPMps8XeMzREj7_RdHBacShGeOjk91WzGw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 3, 2012 at 8:26 PM, Tom Harkaway <tomh(at)hvpa(dot)com> wrote:
> I am having a problem trying to create a language in a new install of
> Postgres
> - I have installed postgres 9.1 on a minimal (i.e. no GUI) CentOS 6.2
> system.
> - Psql is running and I am able to connect to the database from pgAdmin
> running on a Windows box.
> - Postgres was installed in /opt/postgres
> - The data was placed in /var/postgres/data.
>
> I am migrating a database from an 8.4 system to the new system. I am
> trying to add the plperl and plperlu languages, which are used in the 8.4
> system.
>
> The command I am using is:
>
> createlang -U postgres plperl hf-hvpa
>
> The message I get back is:
>
> createlang: language installation failed: ERROR: could not load
> library "/opt/postgres/lib/postgresql/plperl.so": libperl.so: cannot open
> shared object file: No such file or directory
>
> I am doing this as the root user, but I have also tried it using my login
> and as the postgres user. The plperl.so file is in the indicated directory,
> but I am not sure what the reference to libperl.so means. Is that a
> separate file I need to download?
>
> I am fairy new to both Linux and Postgres, however I have successfully
> installed Postgres on a Windows systems.
>
> Sincerely appreciate any help.
>
>
set the LD_LIBRARY_PATH environment variable to the PostgreSQL lib location
location and retry.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
> Tom Harkaway
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-04-04 07:35:00 | Re: what happens when concurrent index create |
Previous Message | Greg Sabino Mullane | 2012-04-04 03:20:42 | Re: Adding new and changed data |