On 04.05.2011 22:27, Tomasz Chmielewski wrote:
Then another pg_clog file disappeared.OK, I have: bookstor=# SELECT * FROM core_wot_seq; sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called ------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+----------- core_wot_seq | 2593 | 1 | 9223372036854775807 | 1 | 1 | 8 | f | t (1 row) bookstor=# SELECT 1 FROM core_wot_seq; ?column? ---------- 1 (1 row) bookstor=# SELECT 1 FROM core_wot_seq FOR UPDATE; ERROR: could not access status of transaction 1573786613 DETAIL: Could not open file "pg_clog/05DC": No such file or directory. How do I best recover from this? Stop postgres, create an empty, 256k pg_clog/05DC file, start postgres? Export table, drop table, import table? Anything else?
Nobody has a clue? :| -- Tomasz Chmielewski http://wpkg.org -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
