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 5/16/2013 2:59 PM, Paul Hammond wrote:
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 directoryWhat 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?
did you build your 9.2 with cygwin? the standard windows binary distributions are built with VisualC, and mixing compilers is likely going to fail.
Anyways, if that pgxs stuff is missing, then your Postgres server was built without the pgxs option, I believe thats a ./configure option (--with-pgxs, or something like that?)
-- john r pierce 37N 122W somewhere on the middle of the left coast
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
On 5/16/2013 11:05 PM, Paul Hammond wrote:
I had downloaded a prepackaged binary from here, I hadn't build it at all, I was only trying to build PlJava. I presume you mean building Postgres from the source in GIT will be required to get the pgxs sources installed that I require.
cygwin isn't a tested or supported environment. the windows version is built and tested with visualC. so you'll be on your own for the makefiles and stuff.
-- john r pierce 37N 122W somewhere on the middle of the left coast
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
Thx John.
I had downloaded a prepackaged binary from here, I hadn't build it at all, I was only trying to build PlJava. I presume you mean building Postgres from the source in GIT will be required to get the pgxs sources installed that I require.
Paul
From: John R Pierce <pierce@hogranch.com>
To: pgsql-general@postgresql.org
Sent: Thursday, 16 May 2013, 23:41
Subject: Re: [GENERAL] PLJava for Postgres 9.2.
On 5/16/2013 2:59 PM, Paul Hammond wrote:
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 directoryWhat 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?
did you build your 9.2 with cygwin? the standard windows binary distributions are built with VisualC, and mixing compilers is likely going to fail.
Anyways, if that pgxs stuff is missing, then your Postgres server was built without the pgxs option, I believe thats a ./configure option (--with-pgxs, or something like that?)
-- john r pierce 37N 122W somewhere on the middle of the left coast
On 5/16/2013 10:51 PM, Paul Hammond wrote: > My question was primarily about obtaining pgsx.mk file which is a part > of the PostgreSQL project. you need the whole PGXS subsystem, which the Windows version doesn't appear to be built with. thats a system for building compatible extensions. ahhh. read this. http://wiki.postgresql.org/wiki/Building_and_Installing_PostgreSQL_Extension_Modules -- john r pierce 37N 122W somewhere on the middle of the left coast
> 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