dbWriteTable permission problem on Mac OSX
postgresqlWriteTable serializes your entire table to disk, and then asks postgres to read it back. It looks like the user name running postgres isn't able to read your file. I'm sure someone on this list will help you solve your permission issues. In case they can't you can try my postgres driver (which writes via binary transfer though the connection). http://github.com/armstrtw/unifieddbi -Whit On Tue, Nov 3, 2009 at 4:35 PM, McGehee, Robert
<Robert.McGehee at geodecapital.com> wrote:
R-Sig-DB, I'm getting a 'Permission denied' error when trying to use the 'dbWriteTable' function (RPostgreSQL\DBI package) to access PostgreSQL on my Mac OSX. I saw that this error appears to have been documented in the README file as affecting versions of Linux running SELinux. However, since my OSX Server is not running SELinux, I wanted to see if anyone else has had success using 'dbWriteTable' on a Mac with RPostgreSQL. I can update a database using INSERT commands, but am looking for a faster solution. Also RODBC crashes my R session when executing the 'sqlTables' function--presumably due to an ODBC driver problem--so switching packages won't easily help. Thanks, Robert ---------------------
dbWriteTable(pcon, "test", data)
Error in postgresqlExecStatement(conn, statement, ...) : ?RS-DBI driver: (could not Retrieve the result : ERROR: ?could not open file "/tmp/RtmprNh2yy/rsdbi60b7acd9" for reading: Permission denied ) Warning in postgresqlWriteTable(conn, name, value, ...) : ?could not load data into table [1] FALSE
R.version
? ? ? ? ? ? ? _ platform ? ? ? x86_64-apple-darwin9.5.0 arch ? ? ? ? ? x86_64 os ? ? ? ? ? ? darwin9.5.0 system ? ? ? ? x86_64, darwin9.5.0 status major ? ? ? ? ?2 minor ? ? ? ? ?9.0 year ? ? ? ? ? 2009 month ? ? ? ? ?04 day ? ? ? ? ? ?17 svn rev ? ? ? ?48333 language ? ? ? R
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db