olivier(dot)macchioni(at)wingo(dot)ch writes:
> When doing the following query on the standby server:
> select * from ir_translation where src = 'a';
> We have the following error in the logfiles:
> ERROR: could not read block 0 in file "base/56100265/57047884": read only 0
> of 8192 bytes
> When checking the file usage, the following is reported:
> postgres(at)db-stdby:~/9.1/main/base/56100265$
> /usr/lib/postgresql/9.1/bin/oid2name -d xx -f 57047884
>> From database "xx":
> Filenode Table Name
> ---------------------------------------
> 57047884 ir_translation_src_hash_idx
"hash_idx"? Is this a hash index? Those aren't supported for replication
purposes (no WAL code :-().
regards, tom lane