Thanks, they do look like the lines you have below. I have separate pg_xlog and pg_clog folders. i'll check the statement logging config, is this the same as transaction logging? On Wed, Aug 20, 2008 at 5:02 PM, Thomas Jacob <jacob@xxxxxxxxxxxxx> wrote: > pg_log isn't a standard postgres dir, > so maybe it's where RHEL stores the > actual textual log files that the > server process generated. > > Indeed this is suggested here: > > http://www.nabble.com/-GENERAL--pg_log-missing-td7753209.html > > So if these files look something like: > > 2008-08-03 00:30:47 CEST LOG: statement: SELECT col1,col2 FROM table1; > 2008-08-03 00:30:47 CEST LOG: statement: SELECT col FROM table2; > > they are just postgres log files, and the server has statement logging > switched on, which is not such a good idea on a busy database. > > But if not they might be RHEL names for pg_xlog or pg_clog > and deleting these would be an active attempt to destroy > your database ;-) > > > > On Wed, Aug 20, 2008 at 04:43:06PM -0400, slamp slamp wrote: >> Hi, I am new to this list sorry for asking such a lame question. I >> tried searching but did not find the answer i was looking for. >> >> I am running postgresql-8.2.4 on rhel5. Do I need the files in pg_log? >> When I look at one of the files, it shows INSERT, UPDATE and SELECT >> statements. Reason I asked is because the folder is about 40GB. It is >> half the size of my /var/lib/pgsql directory. >> >> -- >> Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >
