[BUGS] primary and hot standby database don' work now

2012-07-23 Thread leo xu
hello everyone: my pg version is 9.1.2 running on red hat 5.4 x64 servers.one day,i found all database indexes can't work,reindex database,it can work,but some table has primary key,found exists the same two records in table. primary database error:

[BUGS] Duplicate rows primary key bug

2012-07-23 Thread leo xu
version - PostgreSQL 9.1.2 on red hat 5.4 x64, compiled by GCC 4.1 There are several tables have two same rows with the same primary key. This shouldn't happen. Has this been reported as a bug in this version? -- View

[BUGS] in hot standby database execute select * from pg_class indicate error

2012-05-10 Thread leo xu
hello: i execute any operation in hot standby database,it indicates that index pg_class_relname_nsp_index contains unexpected zero page at block 0,please reindex it.but hot standby server ,it only allow read,not write, i connect to primary server,i can execute any operation. standby

[BUGS] Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619

2012-05-03 Thread leo xu
pg version is 9.1.2 -- View this message in context: http://postgresql.1045698.n5.nabble.com/select-table-indicate-missing-chunk-number-0-for-toast-value-96635-in-pg-toast-2619-tp5682176p5682273.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. -- Sent via pgsql-bugs

[BUGS] select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619

2012-05-02 Thread leo xu
hello: i see a lot ,missing chunk number 0 for toast value 96635 in pg_toast_2619,, in background aler log.select * from iclock ,no data retrun,indicate missing chunk number 0 for toast value 96635 in pg_toast_2619. i use pg_dump table,then truncate table,then pg_dump it current