Thread: BUG #4658: copy problem

The following bug has been logged online:

Bug reference:      4658
Logged by:          Brundle Fly
Email address:      mindquasar@gmail.com
PostgreSQL version: 8.3
Operating system:   Linux
Description:        copy problem
Details:

bdsimple=# copy (select * from customer where customer_id>10) to
'/tmp/clientes.dat' delimiter '|';
COPY 18
bdsimple=# copy (select * from customer where customer_id>10) to
'/tmp/clientes.dat' delimiter '|';
COPY 18
bdsimple=#

This is ok in ubuntu, but in centos doesnt work?.....

Brundle Fly escreveu:
> This is ok in ubuntu, but in centos doesnt work?.....
>
COPY query TO is only available in >= 8.2. Are you sure CentOS is using a 8.3
version too? If so, what is the error message?


--
  Euler Taveira de Oliveira
  http://www.timbira.com/

Euler Taveira de Oliveira escribió:
> Brundle Fly escreveu:
> > This is ok in ubuntu, but in centos doesnt work?.....
> >
> COPY query TO is only available in >= 8.2. Are you sure CentOS is using a 8.3
> version too? If so, what is the error message?

This is probably related to SELinux not giving permissions on files on
/tmp to Postgres processes.  Try "setenforce permissive" or some such.