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 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?

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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 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?

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 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

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

--
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