Search Postgresql Archives

Re: can you please share sample Postgres config file to enable max logging with syslog support?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/21/2014 10:17 PM, M Tarkeshwar Rao wrote:
ERROR:  missing chunk number 0 for toast value 54787 in pg_toast_2619

this error means you have at least one corrupted file. pg_toast data is used to store fields too large for simple tuple storage. a postgres expert could track down which table this toast value belongs to.

until you fix this, and identify the missing data, you should not do anything to this database, or risk further data corruption. in particular you won't be able to do the required pg_dumpall that you need to do a major version upgrade.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux