Thread: PLJava for Postgres 9.2.
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.
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?
Thanks,
Paul
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
Thx.
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.
Paul
From: Andrew Dunstan <andrew@dunslane.net>
To: Paul Hammond <hammpaul70@yahoo.com>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>; "pgsql-general@postgresql.org" <pgsql-general@postgresql.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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> 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@dunslane.net>
> To: Paul Hammond <hammpaul70@yahoo.com>
> Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>;
> "pgsql-general@postgresql.org" <pgsql-general@postgresql.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