Hi Dirk I think there are problems with pg_config, the configure script of RPostgreSQL checks for pg_config and got ¡°checking for pg_config... /usr/bin/pg_config¡±. In Solaris 10u7 X64, three versions of PostgreSQL are installed, there are in /usr/postgres/8.2(8.2.9) and /usr/postgres/8.3(8.3.3), the corresponding bin files are in /usr/postgres/<version>/bin and /usr/postgres/<version>/bin/amd64, and the libraries in /usr/bin is 8.1.11 and it seems a 32bit one, and I can¡¯t find the 64bit version bins for 8.1.11. I'll try uninstall 8.1.11 and install 8.2.9, and my question is how to let RPostgreSQL configure script find the 64bit pg_config.
Xiaobo Gu On Tue, Jul 20, 2010 at 10:32 PM, ¹ËС²¨ <guxiaobo1...@gmail.com> wrote: > 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 > > [[alternative HTML version deleted]]
______________________________________________ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel