Postgres Pro
Downloads
Home   >   mailing lists

Thread: Building an extension for a different version of Postgres

Building an extension for a different version of Postgres

From
Wells Oliver
Date:
I have 9.1 and 9.2 installed, and I am trying to build the PLR extension:


I'm using the USE_PGXS=1 method. But it's building for 9.1:

gcc ....  -I/usr/include/postgresql/9.1/server ...

I want to build for 9.2. How can I do this?

--
Wells Oliver
wellsoliver@gmail.com

Re: Building an extension for a different version of Postgres

From
Raghavendra
Date:
On Thu, Jul 11, 2013 at 11:14 PM, Wells Oliver <wellsoliver@gmail.com> wrote:
I have 9.1 and 9.2 installed, and I am trying to build the PLR extension:


I'm using the USE_PGXS=1 method. But it's building for 9.1:

gcc ....  -I/usr/include/postgresql/9.1/server ...

I want to build for 9.2. How can I do this?

Before compiling point pg_config to PG 9.2

export PATH=/your/path/to/pg92/bin:$PATH

And check whether its pointing to PG 9.2 by below command.
which pg_config

Re-configure plr.

---
Regards,
Raghavendra
EnterpriseDB Corporation
 

Re: Building an extension for a different version of Postgres

From
Wells Oliver
Date:
What is the proper way to repoint pg_config? I'm on Ubuntu Server, so it's in /usr/bin/pg_config, which references 9.1.


On Thu, Jul 11, 2013 at 10:52 AM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
On Thu, Jul 11, 2013 at 11:14 PM, Wells Oliver <wellsoliver@gmail.com> wrote:
I have 9.1 and 9.2 installed, and I am trying to build the PLR extension:


I'm using the USE_PGXS=1 method. But it's building for 9.1:

gcc ....  -I/usr/include/postgresql/9.1/server ...

I want to build for 9.2. How can I do this?

Before compiling point pg_config to PG 9.2

export PATH=/your/path/to/pg92/bin:$PATH

And check whether its pointing to PG 9.2 by below command.
which pg_config

Re-configure plr.

---
Regards,
Raghavendra
EnterpriseDB Corporation
 



--
Wells Oliver
wellsoliver@gmail.com

Re: Building an extension for a different version of Postgres

From
Devrim GÜNDÜZ
Date:
Hi,

On Thu, 2013-07-11 at 10:44 -0700, Wells Oliver wrote:
> I have 9.1 and 9.2 installed, and I am trying to build the PLR extension:
>
> http://www.joeconway.com/plr/doc/plr-install.html
>
> I'm using the USE_PGXS=1 method. But it's building for 9.1:
>
> gcc ....  -I/usr/include/postgresql/9.1/server ...
>
> I want to build for 9.2. How can I do this?

Edit makefile, and find this line:
PG_CONFIG := pg_config

You need to use 9.2 pg_config to build plr against 9.2.

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Attachment