On Tue, Feb 25, 2025 at 6:03 AM sivapostg...@yahoo.com <sivapostg...@yahoo.com> wrote: > > Hello, > > Using PostgreSQL 11.11, compiled by Visual C++ build 1914, 64-bit with > Powerbuilder > > Recently, in one of our customers' places, we got an error while saving a > record from our custom-built application using PowerBuilder. While saving > a record, we compare a value from a table with a hard-coded value in > application. Here the select command failed to fetch that particular record > from the table and so the save failed. > > When we tried to read data from randomly selected tables [ from PGAdmin], we > found that records could not be read from a set of consecutive tables. We > re-started server [ Windows Server 2012 ] and tried again to read those > tables. This time the failure was with only one table and select was success > in all other tables. > > So we dropped that particular table [ around 33000 records ], after removing > all foreign key links and re-created that table and inserted all records from > a backup set. > > The problem got solved. Since this is not the first time, we are getting > this error, I want to know > > 1. Why is corruption happening? How to find out the reason? > 2. What should I do to prevent this from happening again? > > Any steps or suggestions to avoid such corruptions is really appreciated. > Not really a direct answer - - - but - - - have you considered updating Postgresql. Version 11 was EOL (end of life) over a year ago. Version 17 according to the charts I've found is the current version.
HTH
