Re: [GENERAL] Could not read block of temporary files

2015-03-27 Thread R Clarke
I'm using Postgresql 9.1.15 It didn't succeed, which is why the message is confusing. The table was not created. It runs for about 10 minutes and then this error comes up. I tried reindexing the tables but that didn't help. This is the query: create table lu_addresses as SELECT distnct(l.id)

Re: [GENERAL] Could not read block of temporary files

2015-03-25 Thread Adrian Klaver
On 03/25/2015 03:50 AM, Rebecca Clarke wrote: Hi all, I'm creating a table from a select query. During the execution it errors with: ERROR: could not read block 13 of temporary file: Success That is a mixed message. Did the create table succeed? Does it always happen? Could you show the c

[GENERAL] Could not read block of temporary files

2015-03-25 Thread Rebecca Clarke
Hi all, I'm creating a table from a select query. During the execution it errors with: ERROR: could not read block 13 of temporary file: Success I am running Postgresql 9.1 on a Debian/Linux server. Does anyone have any suggestions on what could be causing this? I checked diskspace and permis