Message-ID: <8ec76080911031413x2b157ecbr5c2df4eff1a17ad8@mail.gmail.com>
Date: 2009-11-03T22:13:46Z
From: Whit Armstrong
Subject: dbWriteTable permission problem on Mac OSX
In-Reply-To: <EEBC169715EB8C438D3C9283AF0F201C0724A7A2@MSGBOSCLM2WIN.DMN1.FMR.COM>
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
>