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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: can you please share sample Postgres config file to enable max logging with syslog support?
Date: 2014-12-22 06:39:24
Message-ID: 5497BC9C.3070207@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stefano bonnin 2014-12-22 08:52:33 BDR conpilation error un Ubuntu 12.4 LTS
Previous Message M Tarkeshwar Rao 2014-12-22 06:17:34 Re: can you please share sample Postgres config file to enable max logging with syslog support?