Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0FE7A9FB1C0 for ; Thu, 9 Nov 2006 11:43:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 55538-03 for ; Thu, 9 Nov 2006 15:43:11 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 8DE909FA35C for ; Thu, 9 Nov 2006 11:43:09 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so221476ugf for ; Thu, 09 Nov 2006 07:43:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=TbQ0TWKo734MKOUTJvKpnBlz+PcUSvgcECDy7zHv8M6iRPe1Z6HYrHxa1/4SVb+EJMkW1gpWH3497FXcO8Jn+SSe6Hxu2IuA4NVhgNOt/n7cdEHQA/q2Aeo6zbXv/RspW51L7o2crt1ZI5693jZec8nbkI919ojIdgJRLYau8CY= Received: by 10.66.243.2 with SMTP id q2mr1570680ugh.1163086987027; Thu, 09 Nov 2006 07:43:07 -0800 (PST) Received: by 10.66.252.11 with HTTP; Thu, 9 Nov 2006 07:43:06 -0800 (PST) Message-ID: Date: Thu, 9 Nov 2006 12:43:06 -0300 From: "Marcelo Costa" To: "Antonios Katsikadamos" Subject: Re: posgres headers Cc: pgsql-admin@postgresql.org In-Reply-To: <20061109143308.71352.qmail@web58107.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_67677_28234423.1163086986689" References: <20061109143308.71352.qmail@web58107.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/95 X-Sequence-Number: 23622 ------=_Part_67677_28234423.1163086986689 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Antonios, Don=B4t is 'header' ? what is your real problem ? Message with HEADER generally occurs when you it had a badly recorded page in the system of archives. The Database shutdown before occurring this message ? Another possible cause it would be a memory or damaged disk (in this order of diffidence). Go to the solutions: 1. Enable zero_damaged_pages in pg_settings catalog. With this setting enable the PostgreSQL server erases all defective pages in your table. YOU CAN LOSE INFORMATON WITH THIS= . OR 2. Try find the register(s) defective. Do you can make this for sampling with (SELECT * FROM tab LIMIT x OFFSET y). After to find the register(s) defective, use the xlogdump utility (http://xlogviewer.projects.postgresql.org/docs/) to see the data and insert new other row and to erase the old one. I wait to have helped Marcelo Costa DBA Analist Executive secretariat of Education from Par=E1 Amaz=F4nia - Par=E1 - Brazil 2006/11/9, Antonios Katsikadamos : > > Hi all. Sorry to bother. Does anyone know where the postgres headers are > stored? Which files constitute postgres headers? > > kind regards, > > Antonios > > ------------------------------ > Sponsored Link > > Get a free Motorola Razr! Today Only! Choose Cingular, Sprint, Verizon, Alltel, or T-Mobile. > > --=20 Marcelo Costa ------=_Part_67677_28234423.1163086986689 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Antonios,

Don=B4t is 'header' ? what is your real problem ?
Message with HEADER generally occurs when you it had a badly recorded pag= e
in the system of archives.

The Database shutdown before occurr= ing this message ?

Another possible cause it would be a memory or damaged disk (in thi= s order of diffidence).

Go to the solutions:

1. Enable zero_d= amaged_pages in pg_settings catalog. With this setting enable the PostgreSQ= L server=20
erases all defective pages in your table. YOU CAN LOSE INFORMATON WITH = THIS.

OR

2. Try find the register(s) defective. Do you can ma= ke this for sampling with
(SELECT * FROM tab LIMIT x OFFSET y). After t= o find the register(s) defective,
use the xlogdump utility (http://xlogviewer.projects.postgresql.org/docs/) to see = the data
and insert new other row and to erase the old one.

I wai= t to have helped

Marcelo Costa
DBA Analist
Executive secretariat of Education = from Par=E1
Amaz=F4nia - Par=E1 - Brazil

 

2006/11/9, Antonios Katsikadamos < antonioskatsikadamos@yahoo.com>:
Hi all. Sorry to bother. Does anyone know wher= e the postgres headers are stored? Which files constitute postgres headers?

kind regards,

Antonios

=20


Sponsored Link

Get a free Motorola Razr! Today Only! Choose C= ingular, Sprint, Verizon, Alltel, or T-Mobile.




--
Marcelo Costa ------=_Part_67677_28234423.1163086986689--