Re: pg_log directory

From: Thomas Jacob <jacob(at)internet24(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Cc: slamp slamp <slackamp(at)gmail(dot)com>
Subject: Re: pg_log directory
Date: 2008-08-20 21:02:07
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-admin

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:

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(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


Browse pgsql-admin by date

  From Date Subject
Next Message slamp slamp 2008-08-21 00:08:11 Re: pg_log directory
Previous Message slamp slamp 2008-08-20 20:43:06 pg_log directory