From guxiaobo1982 at gmail.com  Tue Jan 18 15:42:05 2011
From: guxiaobo1982 at gmail.com (Xiaobo Gu)
Date: Tue, 18 Jan 2011 22:42:05 +0800
Subject: [Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64
	crash
In-Reply-To: <alpine.LFD.2.00.1101171711170.2906@toucan.stats.ox.ac.uk>
References: <AANLkTinvoub-z_Le1GVPYswnqTsW1P6MZzLZsztois9K@mail.gmail.com>
	<AANLkTimfKn+qAMP8q2W8nJFvxVdoOM8gYYWZtZU_Jk9w@mail.gmail.com>
	<19764.19953.237115.864920@max.nulle.part>
	<alpine.LFD.2.00.1101171711170.2906@toucan.stats.ox.ac.uk>
Message-ID: <AANLkTi=hX+JF9zPJRzmSi63bpzcVxt4XcHfFOsUhAvFS@mail.gmail.com>

Hi Professor Brian :

I buy a new  64bit Win7 Home basic notebook for working with 64bit R
and PostgreSQL :)

but still now I can't get postgresql-9.0.2-1-windows_x64 installed.

Which version of Win 7 and postgres do you use, can you share the
download URL for 9.0.0.1 of 64bit PostgreSQL, I can't find it form
EnterpriseDB now.

Thanks.

Xiaobo Gu


On Tue, Jan 18, 2011 at 1:22 AM, Prof Brian Ripley
<ripley at stats.ox.ac.uk> wrote:
> On Mon, 17 Jan 2011, Dirk Eddelbuettel wrote:
>
>>
>> On 16 January 2011 at 23:00, Xiaobo Gu wrote:
>> | Is it because of compiler campsites between R and PostgreSQL, R is
>> | compiled by GCC, while PostgreSQL from Enterprise DB is compiled by
>> | Microsoft Visual C ++.
>>
>> So the usual recommendation is to build the matching library (here libpq)
>> with the same compiler, or get the commercial support you are paying for
>> to
>> do it for you.
>>
>> For what it is worth, I deal with one vendor at work where I made that
>> requirement and they had no issue complying / helping me with a MinGW /
>> Rtools-compatible library. ?One of several reasons I like working with
>> that
>> vendor.
>
> And also for what it is worth, RPostgreSQL works for me on x64 Windows 7
> compiled with the Rtools compilers and linked against the initial PostgreSQL
> 9.0 Windows x64 distribution (I've not tried the one you mentioned).
>
> Where C (and not C++) is involved it should be possible to mix DLLs compiled
> by MinGW-w64 and MSVC, and this has been done extensively (after all a lot
> of Windows' own DLLs are compiled with MSVC, as are the Tcl/Tk binaries
> which are distributed with R).
>
>>
>> Dirk
>>
>> | Xiaobo Gu
>> |
>> | On Sat, Jan 15, 2011 at 10:34 AM, Xiaobo Gu <guxiaobo1982 at gmail.com>
>> wrote:
>> | > Hi,
>> | > I build the binary package file of RPostgreSQL 0.1.7 for Windows 2003
>> | > Server R2 64 bit SP2, the software environments are as following:
>> | > ? ? ? ? R 2.12.1 for Win64
>> | > ? ? ? ? RTools212 for Win64
>> | > ? ? ? ? DBI 0.2.5
>> | > ? ? ? ? RPostgreSQL 0.1.7
>> | > ? ? ? ? Postgresql related binaries shipped with
>> | > postgresql-9.0.2-1-windows_x64.exe from EnterpriseDB
>> | >
>> | > The package can be loaded, and driver can be created, but the
>> | > dbConnect function causes the whole RGui crashes,
>> | >
>> | > driver <- dbDriver("PostgreSQL")
>> | > con <- dbConnect(driver, dbname="demo", host="192.168.8.1",
>> | > user="postgres", password="postgres", port=5432)
>> | >
>> |
>> | ______________________________________________
>> | R-devel at r-project.org mailing list
>> | https://stat.ethz.ch/mailman/listinfo/r-devel
>>
>> --
>> Dirk Eddelbuettel | edd at debian.org | http://dirk.eddelbuettel.com
>>
>> ______________________________________________
>> R-devel at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-devel
>>
>
> --
> Brian D. Ripley, ? ? ? ? ? ? ? ? ?ripley at stats.ox.ac.uk
> Professor of Applied Statistics, ?http://www.stats.ox.ac.uk/~ripley/
> University of Oxford, ? ? ? ? ? ? Tel: ?+44 1865 272861 (self)
> 1 South Parks Road, ? ? ? ? ? ? ? ? ? ? +44 1865 272866 (PA)
> Oxford OX1 3TG, UK ? ? ? ? ? ? ? ?Fax: ?+44 1865 272595



[Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64 crash
Xiaobo Gu