Readers,

The following command was entered from normal user account where csv files are:

COPY newdatabasenametable FROM '/path/to/file.csv' WITH CSV;
ERROR: could not open file "/path/to/file.csv" for reading: Permission denied

Superuser X created by linux root account but unable to read csv files
even though permissions are read-execute for others (tried to change
to read-write-execute, no success):

su root
su postgres
createuser X
createdb -U X newdatabasename

When changing to postgres account:

pwd: /path/to/

su root
su postgres
psql newdatabasename
could not change directory to "/path/to
Welcome to psql 8.2.13, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

How do I configure the permissions correctly?

Yours,

postgresql@conference.jabber.org
postgresql8213
mandriva2008

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 5 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedOct 9, '10 at 7:41a
activeOct 11, '10 at 6:44a
posts5
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase