english
- Original Message -
From: Pomarede Nicolas [EMAIL PROTECTED]
To: System/IJS - Joko [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org
Sent: Friday, July 18, 2008 3:16 PM
Subject: Re: [PERFORM] log_statement at postgres.conf
There're 2 points in your question :
- what
On Mon, 21 Jul 2008, System/IJS - Joko wrote:
Thx a lot Nicolas,
I finaly success to log query statement because of your simple explanation.
I have other question:
1. Is there posibility to automatically logging that statement to table?
I don't know, never tried that.
2. All of that
I added the following to FreeBSD:
/etc/newsyslog.conf:
/var/log/postgresql 600 7 *@T00 JC
make new file?
/etc/syslog.conf:
local0.*/var/log/postgresql
/usr/local/pgsql/data/postgresql.conf:
log_destination = 'syslog'
On Fri, 18 Jul 2008, System/IJS - Joko wrote:
I added the following to FreeBSD:
/etc/newsyslog.conf:
/var/log/postgresql 600 7 *@T00 JC
make new file?
/etc/syslog.conf:
local0.*/var/log/postgresql
Dear all,
After setting log_statement='all' at postgres.conf,
then i'm rebooting OS [freeBSD or CentOS],
i can't find where log file created from log_statement='all' located...
FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
many thanks..
Regards,
Joko [SYSTEM]
PT. Indra
After setting log_statement='all' at postgres.conf,
then i'm rebooting OS [freeBSD or CentOS],
i can't find where log file created from log_statement='all' located...
FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
many thanks..
I added the following to FreeBSD:
On Thu, 17 Jul 2008, Claus Guttesen wrote:
After setting log_statement='all' at postgres.conf,
then i'm rebooting OS [freeBSD or CentOS],
i can't find where log file created from log_statement='all' located...
FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
many thanks..