Comments (1)
This is most likely a problem with MacPorts. You might want to forward your
issue to the MacPorts maintainers. Tomoaki's suggestions to do everything form
MacPorts should also fix the problem. Since we do not maintain the MacPorts
ports for R and PostgreSQL I don't want to speak for them and we can't fix them.
For reference to other emails regarding same, binaries do exist outside of
MacPorts:
R - http://cran.r-project.org/bin/macosx/
PostgreSQL -
http://www.postgresqlformac.com/lists/downloads/unified_installer_disk_imag/
The benefit with using the binary from postgresqlformac.com is that you also
get a System Preference panel to start and shut down PostgreSQL, modify server
settings, and a script to allow switching between different PostgreSQL
versions. The only downside of postgresqlformac.com is that updates are
sometimes a month or two behind. That can usually be fixed with a little
prompting as the build process is automated.
Having used both Fink and MacPorts I have settled on using R and PostgreSQL
outside of both because it works better for me although I do use MacPorts for
other software.
I have just confirmed that if PostgreSQL is installed correctly, installing
RPostreSQL from inside R works for both binary and source on OS X 10.8.2
(Mountain Lion).
install.packages('RPostgreSQL')
install.packages('RPostgreSQL', type='source')
'PostgreSQL is installed correctly' means that pg_config is in your path. To
find out if this is the case type 'pg_config' without the quote marks at a
command prompt (in the terminal). You should see some info showing the
locations of your PostgreSQL installation.
For example:
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/postgresql
HTMLDIR = /usr/share/postgresql
INCLUDEDIR = /usr/include
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/serverLIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/man
SHAREDIR = /usr/share/postgresql
SYSCONFDIR = /private/etc/postgresql
PGXS = /usr/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--infodir=/usr/share/info' '--disable-dependency-tracking'
'--prefix=/usr' '--sbindir=/usr/libexec' '--sysconfdir=/private/etc'
'--mandir=/usr/share/man' '--localstatedir=/private/var/pgsql'
'--htmldir=/usr/share/postgresql' '--enable-thread-safety' '--enable-dtrace'
'--with-tcl' '--with-perl' '--with-python' '--with-gssapi' '--with-krb5'
'--with-pam' '--with-ldap' '--with-bonjour' '--with-openssl' '--with-libxml'
'--with-libxslt' '--with-system-tzdata=/usr/share/zoneinfo'
'CC=/Applications/Xcode.app/Contents/Developer/Toolchains/OSX10.8.xctoolchain/us
r/bin/cc' 'CFLAGS=-arch x86_64 -pipe -Os -g -Wall -Wno-deprecated-declarations'
'LDFLAGS=-arch x86_64 -pipe -Os -g -Wall -Wno-deprecated-declarations'
'LDFLAGS_EX=-mdynamic-no-pic'
CC =
/Applications/Xcode.app/Contents/Developer/Toolchains/OSX10.8.xctoolchain/usr/bi
n/cc
CPPFLAGS = -I/usr/include/libxml2
CFLAGS = -arch x86_64 -pipe -Os -g -Wall -Wno-deprecated-declarations -Wall
-Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement
-Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv
CFLAGS_SL =
LDFLAGS = -arch x86_64 -pipe -Os -g -Wall -Wno-deprecated-declarations
-Wl,-dead_strip_dylibs
LDFLAGS_EX = -mdynamic-no-pic
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline
-lm
VERSION = PostgreSQL 9.1.4
This example happens to use PostgreSQL (9.1.4) supplied with mac os x . To
change this simply change the order of directories in the shell PATH to return
the correct pg_config. Keep in mind that since Apple provides a version of
PostgreSQL with all later versions of OS X that you have to always make sure
you are not getting the two versions confused.
To find your current PATH type 'env $PATH' at a command prompt (in the
terminal).
If you prefer not to mess with the operating system PATH then you can also add
something like the following (which is how I use it) to .Rprofile in your user
home directory. This is for using PostgreSQL from postgresqlformac.com as
noted above.
Sys.setenv("PATH" = paste("/Library/PostgreSQL/bin",Sys.getenv("PATH"),sep=":"))
There should not be any need to modify anything in RPostgreSQL to get this
working.
Original comment by [email protected]
on 17 Feb 2013 at 5:19
- Changed state: WontFix
from rpostgresql.
Related Issues (20)
- Error loading RPostgreSQL HOT 6
- 'dbWriteTable()' does not write data out of public schema HOT 4
- configure: error: cannot guess build type; you must specify one in [install.packages("RPostgreSQL")] HOT 2
- Issue installing RPostgreSQL on linux HOT 6
- Unable to install in R HOT 6
- Create Roles and users from RPostgreSQL HOT 4
- dbSendQuery segfault on bad SQL query HOT 1
- How to find headers in /usr/include/psql? HOT 2
- How to pass binary_parameters="yes"? HOT 1
- please support PQconnectdb() interface HOT 2
- `dbConnect()` crashes R Studio instead of erroring HOT 4
- CRAN NEWS and Changelog are out of date
- libpq version 10 or above required for authentication HOT 6
- Old problem: libpg version problems HOT 5
- RPostgreSQL 0.7-4 isn't working with libpq 15.1? HOT 2
- dbListFields incorrectly returns columns which have been removed
- ID class, dbQuoteIdentifier(), and dbUnquoteIdentifier() support
- Incorperating this package as a dependency in another R package
- Enable `DBI::dbIsValid` for RPosgreSQL
- ** CONSIDER USING THE `RPostgres` PACKAGE INSTEAD ** HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from rpostgresql.