| 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
>
>
>
| 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 |