[R-sig-DB] dbWriteTable permission problem on Mac OSX
Whit Armstrong
@rm@trong@wh|t @end|ng |rom gm@||@com
Tue Nov 3 23:13:46 CET 2009
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 using 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 using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
More information about the R-sig-DB
mailing list