[R-sig-DB] R/PostgreSQL

[Dirk Eddelbuettel]

On 10 November 2011 at 11:51, Meike Börder wrote:
| 2)      I tried to install RPostgreSQL, but got an error report that the
| confirmation failed.
| 
|  
| 
| install.packages("RPostgreSQL", type="source")
| 
| Installiere Paket(e) nach �C:/Users/Hinata/Documents/R/win-library/2.13�
| #translation from german: install packages to C:/�
| 
| (da �lib� nicht spezifiziert)
| #�lib� not specified
| 
| versuche URL 'http://cran.rakanu.com/src/contrib/RPostgreSQL_0.2-0.tar.gz'
| #tries URL �http://��
| 
| Content type 'application/x-gzip' length 159167 bytes (155 Kb)
| 
| URL ge�ffnet
| #URL opened
| 
| downloaded 155 Kb
| 
|  
| 
| * installing *source* package 'RPostgreSQL' ...
| 
| ERROR: configuration failed for package 'RPostgreSQL'
| 
| * removing 'C:/Users/Hinata/Documents/R/win-library/2.13/RPostgreSQL'
| 
|  
| 
| Die heruntergeladenen Pakete sind in
| #downloaded packages can be found in folder c:\users�
| 
|         �C:\Users\Hinata\AppData\Local\Temp\RtmpBsQJ05\downloaded_packages�
| 
|  
| 
|  
| 
| What can I do?

If everything else fails, read the documentation. ;-)

To build RPostgreSQL from source you _must have_ the header files and library
installed.  

On Windows, where locations of programs and files are a little less (let's be
charitable here) "predicable" you also need to set an environment variable
PG_HOME to point to the directory holding these files.

I just did this on Windows a couple of days ago, and I effectively had to
install a full PostgreSQL 9.1 installation: PostgreSQL server, PgAdmin,
... just to get the headers and libraries. After setting PG_HOME the package
built like a charm and I am happily talking to a PostgreSQL server on another
machine. 

Beste Gruesse,  Dirk

-- 
"Outside of a dog, a book is a man's best friend. Inside of a dog, it is too
dark to read." -- Groucho Marx