Re: Application Error When Accessing the Table– PostgreSQL 15.18

From: loganathan P <plogandba(at)gmail(dot)com>
To: rob stone <floriparob(at)tpg(dot)com(dot)au>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Application Error When Accessing the Table– PostgreSQL 15.18
Date: 2026-11-04 14:04:45
Message-ID: CAFX4Q9JVJ7Gj3LU9GAKbq5xr5B03OSu1yAwA3NWzahuyaOosYQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear All,

Postgres V15. Did you create the database with checksums enabled?

Answer :- No, the database was not created with data checksums enabled.
Please let me know what the next steps are for recovering the corrupted
table without backup.

Thanks.

Regards,
Loganathan P

On Wed, Nov 4, 2026 at 12:59 PM rob stone <floriparob(at)tpg(dot)com(dot)au> wrote:

> [image: Boxbe] <https://www.boxbe.com/overview> rob stone (
> floriparob(at)tpg(dot)com(dot)au) is not on your Guest List
> <https://www.boxbe.com/approved-list?tc_serial=61984369953&tc_rand=852181494&utm_source=stf&utm_medium=email&utm_campaign=ANNO_MWTP&utm_content=001&&key=sQvI%2FZ0g%2BfQDUqUdXrphBAMhiFC0NvzsaAmfe5y32Pk%3D&token=wOVr7Lg3HI0sNnLdMqI3qOb0UVkab%2B9WCN2pond7s3h1dwHEtnlZlufsRDSh7ahd>
> | Approve sender
> <https://www.boxbe.com/anno?tc_serial=61984369953&tc_rand=852181494&utm_source=stf&utm_medium=email&utm_campaign=ANNO_MWTP&utm_content=001&&key=sQvI%2FZ0g%2BfQDUqUdXrphBAMhiFC0NvzsaAmfe5y32Pk%3D&token=wOVr7Lg3HI0sNnLdMqI3qOb0UVkab%2B9WCN2pond7s3h1dwHEtnlZlufsRDSh7ahd>
> | Approve domain
> <https://www.boxbe.com/anno?tc_serial=61984369953&tc_rand=852181494&utm_source=stf&utm_medium=email&utm_campaign=ANNO_MWTP&utm_content=001&&dom&key=sQvI%2FZ0g%2BfQDUqUdXrphBAMhiFC0NvzsaAmfe5y32Pk%3D&token=wOVr7Lg3HI0sNnLdMqI3qOb0UVkab%2B9WCN2pond7s3h1dwHEtnlZlufsRDSh7ahd>
> Hello,
>
> On Wed, 2026-11-04 at 11:52 +0530, loganathan P wrote:
> > Dear All,
> >
> >
> > While accessing the table through the application, I encountered the
> > following error.
> > ERROR - missing chunk number 0 for toast value 55195659 in
> > pg_toast_171559.
> >
> >
> > Thanks,
> >
> >
> > Regards,
> >
> > Loganathan P
>
>
> That error is usually caused by corruption.
>
> Postgres V15. Did you create the database with checksums enabled?
> It is enabled by default from V18 -- current production version.
>
> This post might be helpful.
>
> https://gist.github.com/supix/80f9a6111dc954cf38ee99b9dedf187a
>
> HTH,
> Robert
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2026-11-04 15:03:54 Re: Application Error When Accessing the Table – PostgreSQL 15.18
Previous Message Laurenz Albe 2026-11-04 07:27:55 Re: Application Error When Accessing the Table – PostgreSQL 15.18