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
