[ADMIN] Fix corrupt pg_toast table?

Hello everyone. Sorry if this has been covered already, I haven't had any luck searching and finding a solution. I have a database which appears to have some corruption in a toast value. When I select a certain table, I get the following error: ERROR: invalid page header in block 984 of relation

Re: [ADMIN] Fix corrupt pg_toast table?

Michael Clark writes: > I have a database which appears to have some corruption in a toast value. > When I select a certain table, I get the following error: > ERROR: invalid page header in block 984 of relation "pg_toast_17341_index" If it's only that index that has gotten damaged, REINDEX will

[ADMIN] Point in Time Recovery (WAL) archive_command

Hello List, i am using the following archive command: archive_command = '/usr/bin/rsync -a -F /data/pgsql/%p pg...@pg-backup:/restore/walfiles/' Which works perfectly so far. My problem now is, what happens if the "pg-backup" server is down for some time and the archove command can not copy th