riakdr(at)gmail(dot)com ("ria ulfa") writes:
> i want to copy table from file with command:
> COPY log FROM '/tmp/logfile.txt';
> but there is error:
> ERROR: could not open file "/tmp/logfile.txt" for reading: Permission denied
> what can i do for repair this error??
> thanks for the answer..
It's worth observing that the louder the demands are in the subject
line, the less likely that people are to *want* to volunteer
The problem here is that COPY accesses data as whatever Unix user is
running the database, typically "postgres" or "pgsql".
Presumably that user hasn't rights to access the file
"/tmp/logfile.txt". Perhaps that needs to be changed.
select 'cbbrowne' || '@' || 'linuxfinances.info';
Rules of the Evil Overlord #145. "My dungeon cell decor will not
feature exposed pipes. While they add to the gloomy atmosphere, they
are good conductors of vibrations and a lot of prisoners know Morse
In response to
pgsql-admin by date
|Next:||From: Chris Hoover||Date: 2008-07-18 20:58:20|
|Subject: Re: Questions on pg_dump|
|Previous:||From: Rex Mabry||Date: 2008-07-18 18:40:47|
|Subject: Re: Stop connections to a specific database|