On Thu, 2009-09-24 at 05:14 -0700, stevesub wrote:
> Hi,
> 
> I have a table of about 693 million rows (80gb) of position data (standard
> object,timestamp,position,etc).
> 
> Every time I try to build some statistics by creating a table, such as:
> > create table pos_stats1 as
> > select id,year,month,count(1) from positions group by id,year,month;
> 
> I get an error:
> > ERROR:  could not read block 8519713 of temporary file: Permission denied
> 
> I get a similar error sometimes on indexes.  What problem am I hitting here? 
> The drive and permissions all seem fine & the query runs for a long time
> before hitting this error.  I've turned off virus scan & it seems to have no
> effect.

It means the permissions on the physical file are such that your
postgres service user can't read them.

Joshua D. Drake

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - 
Salamander


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to