Home > mailing lists

Could not read block of temporary files - Mailing list pgsql-general

From	Rebecca Clarke
Subject	Could not read block of temporary files
Date	March 25, 2015 13:50:46
Msg-id	CAMChtdfDqA=5JDk6fC=rDraVJ9B72LHZ-9Kz3mzHH55rKj5EDA@mail.gmail.com Whole thread Raw
Responses	Re: Could not read block of temporary files (Adrian Klaver <adrian.klaver@aklaver.com>)
List	pgsql-general

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 permissions for the tablespace directory and pgsql_tmp directory and they are fine.

Many thanks

R Clarke

From: Michael Paquier
Date: 25 March 2015, 13:37:46
Subject: Re: reload shared_preload_libraries

From: Peter Mogensen
Date: 25 March 2015, 14:16:54
Subject: BDR - triggers on receiving node?