would a dump/restore correct these issues?
On 10/22/2016 05:59 PM, Tom Lane wrote:
CS DBA <cs_dba@xxxxxxxxxxxxxxxxxxx> writes:
So I ran REINDEX on all the db's and the errors went away for a bit. Now
I'm seeing this:
Log entries like this:FATAL: could not read block 0 of relation
base/1311892067/2687: read only 0 of 8192 bytes
You have a problem there, because:
regression=# select 2687::regclass;
regclass
----------------------
pg_opclass_oid_index
(1 row)
which is a pretty critical index.
You might be able to fix this by starting a single-user backend with -P
(--ignore-system-indexes) and using it to REINDEX that index.
On the whole, though, it's starting to sound like that system has
got major problems. You'd be well advised to focus all your efforts
on getting a valid dump, not bringing it back into production.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
