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(at)internet24(dot)de> 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:
> 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
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2008-08-21 01:38:01|
|Subject: Re: pg_log directory |
|Previous:||From: Thomas Jacob||Date: 2008-08-20 21:02:07|
|Subject: Re: pg_log directory|