Frank Alberto Rodriguez wrote:
> This morning the logs are showing me this error when I make a connection with
> an specific database.
>
> [
> ERROR: index "pg_proc_proname_args_nsp_index" contains unexpected zero page
> at block 16 at character 61
> ]
>
> I create a new database but I don't know where to find the origin of the
> problem, or how to avoid this. Any idea would be helpful.
Ths looks like data corruption.
Could be a hardware problem or a PostgreSQL bug.
Were there any crashes lately?
Since this is an index, running
REINDEX TABLE pg_proc;
as superuser would fix the problem.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com