Re: [HACKERS] PLJava for Postgres 9.2.

> Yes, am aware PLJava is a 3rd party lib, just surprised the same party
> hasn't built them given they seem to be built all the way to 9.1.
>
> My question was primarily about obtaining pgsx.mk file which is a part of
> the PostgreSQL project.

With linux you do something like that for pljava

$ make PG_CONFIG=/usr/pgsql-9.2/bin/pg_config \
JAVA_HOME=/usr/java/default

The pg_config is used to find the pgxs.mk (the real command is: «pg_config --
pgxs»).

>
> Paul
>
>
> ________________________________
> From: Andrew Dunstan <andrew(at)dunslane(dot)net>
> To: Paul Hammond <hammpaul70(at)yahoo(dot)com>
> Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>;
> "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> Sent:
> Friday, 17 May 2013, 0:03
> Subject: Re: [GENERAL] [HACKERS] PLJava for Postgres 9.2.
>
> On 05/16/2013 05:59 PM, Paul Hammond wrote:
> > Hi all,
> >
> > I've downloaded PLJava, the latest version, which doesn't seem to have
> > a binary distribution at all for 9.2, so I'm trying to build it from
> > the source for Postgres 9.2. I have the DB itself installed on Windows
> > 7 64 bit as a binary install. I've had to do a fair bit of hacking
> > with the makefiles on cygwin to get PLJava to build, but I have
> > succeeded in compiling the Java and JNI code, the pljava_all and
> > deploy_all targets effectively.
>
> Cygwin is not a recommended build platform for native Windows builds.
> See the docs for the recommended ways to build Postgres.
>
> > But I'm coming unstuck at the next target where it's doing the target
> > c_all. It's trying to find the following makefile in the Postgres dist:
> >
> > <my postgres installation dir>/lib/pgxs/src/makefiles/pgxs.mk: No such
> > file or directory
> >
> > What do I need to do to obtain the required files, and does anybody
> > know why, given Postgres 9.2 is out some time, and 9.3 is in beta, why
> > no prebuild binary PLJavas exist for 9.2?
>
> Because nobody has built them?
>
>
> FYI, PL/Java is not maintained by the PostgreSQL project.
>
>
> cheers
>
> andrew

--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation