Re: unable to create new table - Mailing list pgsql-admin

From Chandra Sekar R
Subject Re: unable to create new table
Date
Msg-id 2d48a3680906292210g6a69937bu88bd65e3e094fcdc@mail.gmail.com
Whole thread Raw
In response to Re: unable to create new table  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-admin

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
========

On 6/30/09, raghu ram <raghuchennuru@gmail.com> wrote:
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


On Tue, Jun 30, 2009 at 9:57 AM, Chandra Sekar R <chandrasekar@visiontss.com> wrote:
Hi, Kevin,
 
Thank you for your inputs.
 
Since I am very new to Postgresql, how i can see logs and postgresql.conf file ?

thanks
Chandrasekar R.
----------


On 6/29/09, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
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

 


pgsql-admin by date:

Previous
From: raghu ram
Date:
Subject: Re: unable to create new table
Next
From: Brian Modra
Date:
Subject: Fwd: large cache