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@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote:
Hi, Kevin,Thank you for your inputs.Since I am very new to Postgresql, how i can see logs and postgresql.conf file ?
thanksChandrasekar R.----------
On 6/29/09, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote:Chandra Sekar R <chandrasekar@xxxxxxxxxxxxx> 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