Добрый день.
Подскажите пожалуйста как восстанвоить каталог pg_rewrite
vacuum и reindex не помогают.
[postgres@......01 ~]$ psql -x -d ......_prod -c "select ev_action from pg_rewrite;"
ERROR: unexpected chunk number 2 (expected 0) for toast value 78482 in pg_toast_2618
[postgres@......01 ~]$ psql -x -d ......_prod -c "select * from slr_debcard limit 10;"
ERROR: unexpected chunk number 4 (expected 1) for toast value 77900 in pg_toast_2618
LINE 1: select * from slr_debcard limit 10;
^
[postgres@k......01 ~]$ psql -x -d ......_prod -c "select 2618::regclass;"
-[ RECORD 1 ]--------
regclass | pg_rewrite
[postgres@......01 ~]$ psql -x -d ......_prod -c "select 2838::regclass;"
-[ RECORD 1 ]--------------------
regclass | pg_toast.pg_toast_2618
[postgres@......01 ~]$
Только из бакапа.
Только из бакапа.