From: | Chandra Sekar R <chandrasekar(at)visiontss(dot)com> |
---|---|
To: | raghu ram <raghuchennuru(at)gmail(dot)com> |
Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: unable to create new table |
Date: | 2009-06-30 05:10:58 |
Message-ID: | 2d48a3680906292210g6a69937bu88bd65e3e094fcdc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)visiontss(dot)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(at)gmail(dot)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(at)visiontss(dot)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(dot)Grittner(at)wicourts(dot)gov> wrote:
>>>
>>> Chandra Sekar R <chandrasekar(at)visiontss(dot)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
>>>
>>
>>
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Modra | 2009-06-30 05:19:13 | Fwd: large cache |
Previous Message | raghu ram | 2009-06-30 04:59:06 | Re: unable to create new table |