DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=ryEIJEdYT58LbHFXAqGJwIeU0VSFwYRgeyAodCvakl/mWmV1ucc2+nxdX/BobUXoim
	nhENVUPgICRNMtyK8jlqPXkIAA9u0ElAj74rIemWGB+2yfJ93EG4c7Z4hDOwW0CkHjjv
	0gMjZ/8mtHL3Q0vB0umdK1gzBly7e4MHG8AsE=
Message-ID: <78926d250808201708l72592275hb7fdbdc83c8118a5@mail.gmail.com>
Date: Wed, 20 Aug 2008 20:08:11 -0400
From: "slamp slamp" <slackamp@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_log directory
In-Reply-To: <20080820210207.GA1945@internet24.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <78926d250808201343x41e6840cma213c92572ec4268@mail.gmail.com>
	<20080820210207.GA1945@internet24.de>

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@internet24.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:
>
> 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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>