Re: BUG #4658: copy problem

Lists: pgsql-bugs
From: "Brundle Fly" <mindquasar(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4658: copy problem
Date: 2009-02-16 09:39:29
Message-ID: 200902160939.n1G9dTWD063856@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4658
Logged by: Brundle Fly
Email address: mindquasar(at)gmail(dot)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?.....

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Brundle Fly <mindquasar(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4658: copy problem
Date: 2009-02-16 14:10:25
Message-ID: 499973D1.1060301@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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/

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
Cc: Brundle Fly <mindquasar(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4658: copy problem
Date: 2009-02-17 15:55:25
Message-ID: 20090217155525.GB3173@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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.