Hey Tom,
Had a small query here.
If we have streaming replication enabled, and if we have corruption like this
due to power loss etc,
is it safe to assume we failover to standby and we should be good (atleast in
most cases)
I wanted to understand if the system catalog is corrupted, for some re
>This suggests you've actually lost some entries from pg_proc. Have
>you had any system crashes or suchlike?
yes two crashes for power outages, this guys doesn't have dumps recent, only
to 2 days ago, I try recover the much data as possible.
>No, pg_upgrade can't magically restore data that's n
DrakoRod writes:
> I reindex the pg_proc table and reindex finished correctly but I try read
> the tables or make the dump and same error, reindexed the database and show
> me this error:
> ERROR: cache lookup failed for function 125999
This suggests you've actually lost some entries from pg_p
Hi Tom
I reindex the pg_proc table and reindex finished correctly but I try read
the tables or make the dump and same error, reindexed the database and show
me this error:
ERROR: cache lookup failed for function 125999
Any suggestions, If I run pg_upgrade to 10, will these errors be corrected?
DrakoRod writes:
> I've a big problem with a database, is a PostgreSQL 9.6 version on Ubuntu.
> When a tried read some tables (approximately 7 of 1073) show this error:
> *ERROR: cache lookup failed for function 125940*
> So, I was reading this like data corruption specially the postgresql's
>
