From: Thomas Jacob <jacob@internet24.de>
To: pgsql-admin@postgresql.org
Cc: slamp slamp <slackamp@gmail.com>
Subject: Re: pg_log directory
Date: Wed, 20 Aug 2008 23:02:07 +0200
Message-ID: <20080820210207.GA1945@internet24.de> (raw)
In-Reply-To: <78926d250808201343x41e6840cma213c92572ec4268@mail.gmail.com>
References: <78926d250808201343x41e6840cma213c92572ec4268@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jacob@internet24.de, slackamp@gmail.com
Subject: Re: pg_log directory
In-Reply-To: <20080820210207.GA1945@internet24.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox