Skip site navigation (1) Skip section navigation (2)

Re: unable to create new table

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Chandra Sekar R <chandrasekar(at)visiontss(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 04:59:06
Message-ID: d331f2ee0906292159u1e329e96y3db4f57f82033c0b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
>>
>
>

In response to

Responses

pgsql-admin by date

Next:From: Chandra Sekar RDate: 2009-06-30 05:10:58
Subject: Re: unable to create new table
Previous:From: Chandra Sekar RDate: 2009-06-30 04:27:05
Subject: Re: unable to create new table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group