Обсуждение: unable to create new table

June 30, 2009

Hi All,
 
I recently installed PostgreSQL 8.3.7 into my windows xp m/c.
I have created 4 tables using PgadminIII in postgres db and public schema with PK, UK,
constraints and after I shutdown the pc.

next time when i start my pc and I unable to create new table the following error occured:

ERROR: invalid page header in block 95 of relation "pg_attribute".

any remedy?
 
thanks
chandrasekar R.
--------------

 

Chandra Sekar R <chandrasekar@visiontss.com> wrote:

> I have created 4 tables using PgadminIII in postgres db and public
> schema with PK, UK, constraints and after I shutdown the pc.

Was PostgreSQL gracefully shutdown?  (The logs should tell you.)

> next time when i start my pc and I *unable to create new table* the
> following error occured:
>
> *ERROR: invalid page header in block 95 of relation "pg_attribute".*

Please show the contents of your postgresql.conf file (excluding
comments).

-Kevin

On Mon, Jun 29, 2009 at 12:20 AM, Chandra Sekar
R<chandrasekar@visiontss.com> wrote:
> June 30, 2009
>
> Hi All,
>
> I recently installed PostgreSQL 8.3.7 into my windows xp m/c.
> I have created 4 tables using PgadminIII in postgres db and public schema
> with PK, UK,
> constraints and after I shutdown the pc.
>
> next time when i start my pc and I unable to create new table the following
> error occured:
>
> ERROR: invalid page header in block 95 of relation "pg_attribute".

Are you running aanti-virus software on this machine?  That's a common
cause of these issus on windows.

On Mon, Jun 29, 2009 at 4:56 PM, Scott Marlowe<scott.marlowe@gmail.com> wrote:
>> ERROR: invalid page header in block 95 of relation "pg_attribute".
>
> Are you running aanti-virus software on this machine?  That's a common
> cause of these issus on windows.

Is it? I thought it mainly caused random errors when connecting or
opening files. Not data corruption on disk.

I would be more inclined to blame bad memory or a bad hard drive,
though that also seems a bit unlikely to bite so quickly.

Are the column names sensitive data? Could you send your pg_attributes
data file? The data file in question will be named
<datadir>/base/11510/1249. (Actually the 11510 might vary, but if
you've only created one database it'll be the one that isn't "1".) If
you can extract bytes 778240-786432 then great, otherwise the whole
file probably isn't very big.

Hm, actually if you've gotten as far as 800k already in pg_attributed
then you've done a whole lot more than create four tables or something
else has added a ton of extra data to this file. Incidentally my
regression database has a pg_attribute that's just about that size.
Have you run "make check"?

--
greg
http://mit.edu/~gsstark/resume.pdf

On Mon, Jun 29, 2009 at 9:57 PM, Greg Stark<gsstark@mit.edu> wrote:
> On Mon, Jun 29, 2009 at 4:56 PM, Scott Marlowe<scott.marlowe@gmail.com> wrote:
>>> ERROR: invalid page header in block 95 of relation "pg_attribute".
>>
>> Are you running aanti-virus software on this machine?  That's a common
>> cause of these issus on windows.
>
> Is it? I thought it mainly caused random errors when connecting or
> opening files. Not data corruption on disk.

I've seen a few posts go by where anti-virus caused a broken file on disk.

Hi,

we can find below are the location of  logs and postgresql.conf file

windows:-

C:\Program Files\PostgreSQL\8.2\data\pg_log
C:\Program Files\PostgreSQL\8.2\data\postgresql.conf

Linux:-

/usr/local/pgsql/data/pg_log

/usr/local/pgsql/data/postgresql.conf

Thanks & Regards,
Raghu

Hi, Raghu,

Thank you for your info.

i will see logs and postgresql.conf file  and send to all.

thanks
R.Chandrasekar
Accountant
India Development Center
Mobile: 9344564849
E-mail: chandrasekar@visiontss.com
Web: http://www.visiontss.com
-----------
Vision Tech Solutions Pvt. Ltd.,
DD12, 4th Cross, Annanagar,
Tennur, Trichy 620 017,
Tamilnadu, India.
Phone: (91)-431-2791568
========