Re: [PERFORM] log_statement at postgres.conf

2008-07-20 Thread System/IJS - Joko
--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

Re: [PERFORM] log_statement at postgres.conf

2008-07-17 Thread System/IJS - Joko
>> 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

[PERFORM] log_statement at postgres.conf

2008-07-17 Thread System/IJS - Joko
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