Thread: problem with COPY command

I have a problem to populate a database with the copy command

my write command are:

> COPY telefono FROM '/home/alain/Documents/prueba2.txt'
>  WITH DELIMITER AS ',';

The pgsql server answer the following:

> ERROR:  COPY command, running in backend with effective uid 26, could
> not open file '/home/alain/Documents/prueba2.txt' for reading.  Errno
> = Permiso denegado (13).


Thank you for your atention

Alain Hermosilla
ahermosi@lonquensur.cl

Alain Hermosilla Ringger wrote:
> I have a problem to populate a database with the copy command
>
> my write command are:
>
> > COPY telefono FROM '/home/alain/Documents/prueba2.txt'
> >  WITH DELIMITER AS ',';
>
> The pgsql server answer the following:
>
> > ERROR:  COPY command, running in backend with effective uid 26, could
> > not open file '/home/alain/Documents/prueba2.txt' for reading.  Errno
> > = Permiso denegado (13).

COPY runs as the owner of the backend process, not of the client. You
can either give the backend owner permission to read the file or psql
\copy, which runs locally.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073