Re: PLJava for Postgres 9.2.

John R Pierce <pierce@xxxxxxxxxxxx> · Thu, 16 May 2013 15:41:36 -0700



    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