similar to: Installing RPostgreSQL from source on Mac OS X

Dear all, I'm an absolute R-beginner and want to connect to my PostgreSQL DB (on my local Mac OSX 10.6). 1) I tried to install RPostgreSQL (Package Installer > CRAN (sources)) and get this log below. There seems to be an issue with libpq, bug I don't have any clue how to fix this. What can I do? 2) Once this issue is solved, should this code work? drv <-

I have set up a postgresql database that I connect to each R startup in my .Rprofile file. ##############relevant lines from .Rprofile############################ library(RPostgreSQL) m <- PostgreSQL() con <- dbConnect(m, user="xxx", password="yyy", dbname="zzz") ####################################################################### in R con <Expired

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

Hi, I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the RPostgreSQL package for interfacing with a postgresql database. I am using postgresql 8.3.7. A query that works from the postgresql terminal is causing a segfault when executed from R. My sessionInfo, the error message, and the R code used to generate the error are listed below. I have noticed that a

Hi Everybody Is there a way in which one can use the RPostgreSQL package to take a sample from a table in Postgres database without having to read the whole table into R regards Christiaan [[alternative HTML version deleted]]

I have a large dataset (questionnaire results) of mostly categorical variables. I have tested for dependency between the variables using chi-square test. There are an incomprehensible number of dependencies. I used the chaid() function in the CHAID package to detect interactions and separate out (what I hope to be) the underlying structure of these dependencies for each variable. What typically

Hallo Everybody Consider the following vector a=1:10 b=20:30 c=40:50 x=c(a,b,c) I need a function that can tell me that there are three set of continuos sequences and that the first is from 1:10, the second from 20:30 and the third from 40:50. In other words: a,b, and c. regards Christiaan [[alternative HTML version deleted]]

Hi everybody I am a recent convert from SAS so please excuse me if this is all very obvious: I want to use the runs test {runs.test() in package tseries} to test the randomness of a certain variable in a survey for each interviewer. I tried to us the by() statement but it doesn't seem to work with runs.test() as the function. Here is what I have: Consider a data frame with two variables and

I'm starting to seriously use R and have tried to solve this issue using my reference books but I'm missing something simple. Running R-2.13.1 on Slackware-13.1. Trying to invoke RPostgreSQL so I can copy data from a postgres table to an R data-frame. I installed RPostgreSQL and the library() command shows it's present: Packages in library

Hi everybody. I have a dataframe that contains a factor with the date information in the format like in the example below: "2009/05/12 11:22:31 AM" I have been able to convert it to POSIXt using strptime Now I want to print only the date as one vector and the time in another vector but they must be real date and time classes so that i can use them in calculations to reconstruct my

Hi everybody. I want to identify not only duplicate number but also the original number that has been duplicated. Example: x=c(1,2,3,4,4,5,6,7,8,9) y=duplicated(x) rbind(x,y) gives: [,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10] x 1 2 3 4 4 5 6 7 8 9 y 0 0 0 0 1 0 0 0 0 0 i.e. the second 4 [,5] is a duplicate. What I want is

Hi, I am getting the following error while trying to install RPostgreSQL. I tried all three methods(install.packages("RPostgreSQL", type = "source"),install.packages("RPostgreSQL") & R CMD INSTALL RPostgreSQL_0.3-1.tar.gz ) , but none of them is working. ++++++++++++++++++ Error++++++++++++++++++++++++ gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I

Dear list users, The problem occurs when library(RPostgreSQL) is issued on R. This issue has previously appeared on R mailing list without any robust solution. The error message issued by R: Loading required package: RPostgreSQL Loading required package: DBI Error in inDL(x, as.logical(local), as.logical(now), ...) : unable to load shared library

RPostgreSQL version 0.1.0 We are pround to announce the availability of the RPostgreSQL package on CRAN and its mirrors. This package provides an a DBI-compliant interface between PostgreSQL and R. RPostgreSQL was developed as part of the Google Summer of Code 2008 program by Sameer Kumar Prayaga. Some highlights: o Implemented all the DBI features o Added support for transaction

RPostgreSQL version 0.1.0 We are pround to announce the availability of the RPostgreSQL package on CRAN and its mirrors. This package provides an a DBI-compliant interface between PostgreSQL and R. RPostgreSQL was developed as part of the Google Summer of Code 2008 program by Sameer Kumar Prayaga. Some highlights: o Implemented all the DBI features o Added support for transaction

Hello, I am trying to install RPostgreSQL, but without success at the moment, getting an errormessage - see below. My OS is Fedora 17, R version 2.15.2, PostgreSQL 9.2.1 with Postgis 2.0.1 spatial extension. Thank You for any help, advice or hint in advance. Regards Tomas > install.packages("RPostgreSQL", dependencies=TRUE) trying URL

hello, if i load the RSQLite package in addition to the RPostgreSQL package, i get various errors when trying to use RPostgreSQL functions. here is an example transcript showing one such error: ========================================================== R version 2.15.0 (2012-03-30) [...] > packageVersion('RPostgreSQL') [1] 0.3.2 > packageVersion('RSQLite') [1] 0.11.1

Hello list, I'm using R 2.9.2 on a WinXP system, and I installed the RPostgreSQL library using the package installer. When trying to load it, I get the following error: > library('RPostgreSQL') Error in inDL(x, as.logical(local), as.logical(now), ...) : unable to load shared library 'C:/PROGRA~1/R/R/library/RPostgreSQL/libs/RPostgreSQL.dll': LoadLibrary failure: The

Hi, I've just started using RPostgreSQL within R to interrogate a PostgreSQL database. The problem I have is that a column containing dates shows up differently in R than in the database: here is the output direct from the psql database in Linux: db=> select pat_dob_dt from patients where pat_dob_dt like '%1980'; pat_dob_dt ------------ 04/05/1980 01/12/1980 04/05/1980

Hi everybody Im on R version 2.11.1 on Mac OS X I am working through David Kahle's example of using ggplot2 with Rgooglemaps (found here: https://github.com/hadley/ggplot2/wiki/Crime-in-Downtown-Houston,-Texas-:-Combining-ggplot2-and-Google-Maps). Excellent page by the way. I have downloaded the data and the code and want to learn how to do this by first simulating David's results and