Hi Dirk,
I think this discussion should help :
http://stackoverflow.com/questions/1836333/how-can-i-compile-64-bit-postgres-bindings-for-perl-on-solaris,
are there environment variables I can set to point to 64bit libraries, or I
can set the 64bit libraries path /usr/local/psql/lib before /usr/lib, I'll
let you know the results tomorrow.
Xiaobo.Gu
-----Original Message-----
From: Dirk Eddelbuettel [mailto:e...@debian.org]
Sent: Tuesday, July 20, 2010 7:11 PM
To: Amber
Cc: Dirk Eddelbuettel; Uwe Ligges
Subject: Re: Package RPostgreSQL_0.1-6.tar.gz has been checked and built
Hi Amber,
I'm at the useR conference with imperfect connectivity adn can't help much.
I
also noticed that Solaris often comes up with particular errors -- see Prof
Ripley's response to your Rattle query.
RPostgresql may be easy to get built, but you may have to adapt
configure.in.
On 20 July 2010 at 14:08, Amber wrote:
| Hi Dirk,
| There are problems building RPostgreSQL on 64bit solaris,
| The server has preinstalled PostgreSQL 8.1 client and server binaries ,
and
| we also installed Greenplum SNE 3.3.5.0 server and client installed, but
the
| postgres user, which I used to build R and RPostgreSQL can't see
Greenplum
| binaries, the error messages are:
|
| -bash-3.00$ R CMD INSTALL RPostgreSQL
| * installing to library '/opt/R/R2-11-1/lib/R/library'
| * installing *source* package 'RPostgreSQL' ...
| checking for gcc... /opt/sunstudio12.1/bin/cc -m64
| checking for C compiler default output file name... a.out
| checking whether the C compiler works... yes
| checking whether we are cross compiling... no
| checking for suffix of executables...
| checking for suffix of object files... o
| checking whether we are using the GNU C compiler... no
| checking whether /opt/sunstudio12.1/bin/cc -m64 accepts -g... yes
| checking for /opt/sunstudio12.1/bin/cc -m64 option to accept ISO C89...
none
| needed
| checking for pg_config... /usr/bin/pg_config
| checking for "/usr/include/pgsql/libpq-fe.h"... yes
Good!
| configure: creating ./config.status
| config.status: creating src/Makevars
| ** libs
| /opt/sunstudio12.1/bin/cc -m64 -xc99=all -G -L/opt/R/R2-11-1/lib
| -L/usr/sfw/lib/amd64 -L/usr/lib/amd64 -L/opt/sfw/lib -o RPostgreSQL.so
| RS-DBI.o RS-PostgreSQL.o -L/usr/lib -lpq
| ld: fatal: file /usr/lib/libpq.so: wrong ELF class: ELFCLASS32
| ld: fatal: File processing errors. No output written to RPostgreSQL.so
The linker complained about bad objkect files. Looks like you have a wrong
or
mismatched Pg library. We'd have to fix that first before RPostgreSQL can
be
built.
Also ask Greenplum if they can help. At least they get paid for this :)
Dirk
| *** Error code 1
| The following command caused the error:
| if test "zRS-DBI.o RS-PostgreSQL.o" != "z"; then \
| echo /opt/sunstudio12.1/bin/cc -m64 -xc99=all -G -L/opt/R/R2-11-1/lib
| -L/usr/sfw/lib/amd64 -L/usr/lib/amd64 -L/opt/sfw/lib -o RPostgreSQL.so
| RS-DBI.o RS-PostgreSQL.o -L/usr/lib -lpq ; \
| /opt/sunstudio12.1/bin/cc -m64 -xc99=all -G -L/opt/R/R2-11-1/lib
| -L/usr/sfw/lib/amd64 -L/usr/lib/amd64 -L/opt/sfw/lib -o RPostgreSQL.so
| RS-DBI.o RS-PostgreSQL.o -L/usr/lib -lpq ; \
| fi
| make: Fatal error: Command failed for target `RPostgreSQL.so'
| ERROR: compilation failed for package 'RPostgreSQL'
| * removing '/opt/R/R2-11-1/lib/R/library/RPostgreSQL
|
| On Sun, Jul 18, 2010 at 10:50 PM, ?????? <guxiaobo1...@gmail.com> wrote:
|
| > Hi,
| > I have successfully built and installed DBI and RPostgreSQL on
32bit
| > Solaris, and will repeat in on our 64bit production server tomorrow,
I'll
| > let you know the results.
| >
| > We still waiting for the building toolset for win64 to mature.
| >
| > Xiaobo.Gu
| >
| >
| > -----Original Message-----
| > From: Dirk Eddelbuettel [mailto:e...@debian.org]
| > Sent: Sunday, July 18, 2010 9:59 PM
| > To: ??????
| > Cc: 'Dirk Eddelbuettel'; 'Uwe Ligges'
| > Subject: RE: Package RPostgreSQL_0.1-6.tar.gz has been checked and
built
| >
| >
| > Hi again,
| >
| > On 18 July 2010 at 21:41, ?????? wrote:
| > | Hi Dirk,
| > | We have tested RPostgreSQL against 64bit RODBC both on the same
| > 64bit Windows Server.
| > |
| > | The Environments are as following:
| > |
| > | Case 1: 32bit R 2.11.1, 32bit RPostgreSQL,
| > | data <- dbGetQuery(con, "select * from optest.colana limit 50000")
| > | It takes about 1.5 minute to run
| > |
| > | Case2: 64bit R 2.11.1, 64bit RODBC, and 64bit DataDirect ODBC to
| > Greenplum
| > | data <- sqlQuery(con, "select * from optest.colana limit 50000")
| > | It runs for at least 10 minutes and still running when I kill the
whole R
| > process
| >
| > That's pretty shocking!
| >
| > | It yields out that RPostgres have great performance advantages, we
will
| > try to build RPostgreSQL on 64bit Solaris 10 u7 platform next.
| >
| > Keeping the comparison 'apples to apples' could you build Postgresql on
| > Windows 64, so that you could build RPostgreSQL against it?
| >
| > Dirk
| >
| > | Xiaobo.Gu
| > |
| > | -----Original Message-----
| > | From: Dirk Eddelbuettel [mailto:e...@debian.org]
| > | Sent: Monday, June 28, 2010 11:34 PM
| > | To: Uwe Ligges
| > | Cc: e...@debian.org; ?????????3??
| > | Subject: Re: Package RPostgreSQL_0.1-6.tar.gz has been checked and
built
| > |
| > |
| > | Uwe,
| > |
| > | On 28 June 2010 at 16:57, Uwe Ligges wrote:
| > | | Dirk,
| > | |
| > | | da ist derzeit kein 64-bit PostgreSQL auf winbuilder.
| > |
| > | I know that -- but it wasn't me but someone who really badly wants
this
| > on
| > | Windows and is seemingly in several threads on the R lists as well as
in
| > my
| > | inbox and who didn't edit the DESCRIPTION file before uploading this.
| > |
| > | Tschoe, Dirk
| > |
| > | |
| > | | Gruss,
| > | | Uwe
| > | |
| > | |
| > | |
| > | | On 28.06.2010 16:36, uwe.lig...@r-project.org wrote:
| > | | > Dear package maintainer,
| > | | >
| > | | > this notification has been generated automatically.
| > | | > Your package RPostgreSQL_0.1-6.tar.gz has been built (if working)
and
| > checked for Windows.
| > | | > Please check the log files and (if working) the binary package
at:
| > | | > http://win-builder.r-project.org/HLQti73j3Y90
| > | | > The files will be removed after roughly 72 hours.
| > | | > Installation time in seconds: 2
| > | | > Check time in seconds: 43
| > | | > Check result: ERROR
| > | | > R version 2.11.1 (2010-05-31) (64-bit)
| > | | >
| > | | > All the best,
| > | | > Uwe Ligges
| > | | > (CRAN maintainer of binary packages for Windows)
| > | | >
| > |
| > | --
| > | Regards, Dirk
| > |
| >
| > --
| > Regards, Dirk
| >
| >
--
Dirk Eddelbuettel | e...@debian.org | http://dirk.eddelbuettel.com
