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 <[email protected] > 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 <[email protected]> wrote: >> >> Chandra Sekar R <[email protected]> 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 >> > >
