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 stateme
--sorry for my bad english
- Original Message -
From: "Pomarede Nicolas" <[EMAIL PROTECTED]>
To: "System/IJS - Joko" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, July 18, 2008 3:16 PM
Subject: Re: [PERFORM] log_statement at postgres.conf
There're 2 poin
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
/usr/local/pgsql/data/po
>> 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_destina
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..
I
> 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:
/e
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 Jaya