[PERFORM] invalid page header in block 428 of relation "pg_attribute"

2007-02-25 Thread [EMAIL PROTECTED]
Hello List, I'm using postgresql 7.4 on FC4. When i run following query on postgresql prompt, it gives error. indse96=# CREATE TEMP TABLE aggregate AS ( SELECT vc_vouchno ,vc_srno,vc_type ,vc_vouchdt,trim(''),vc_descrip, ( CASE WHEN (vc_dr_cr='D') THEN vc_amount ELS

Re: [PERFORM] Two hard drives --- what to do with them?

2007-02-25 Thread Peter Kovacs
A related question: Is it sufficient to disable write cache only on the disk where pg_xlog is located? Or should write cache be disabled on both disks? Thanks Peter On 2/25/07, Tom Lane <[EMAIL PROTECTED]> wrote: Carlos Moreno <[EMAIL PROTECTED]> writes: > The question is: does PostgreSQL have