From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | log file |
Date: | 2001-06-20 04:44:08 |
Message-ID: | Pine.BSF.4.10.10106192133000.24483-100000@tidal.ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-sql |
Tom,
We turn on the log file by:
In file 'postgresql.conf'
syslog = 2 # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
1. It seems that postmaster writes stuff undef /db/pgsql/pg_xlog
(they are not text files).
2. the log file I expected (I want log include SQL statement and ERROR)
Just have NOTICE and DEBUG info.
How to choose these options??
Thanks.
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2001-06-20 05:05:50 | pg_xlog |
Previous Message | Rainer Mager | 2001-06-20 03:40:22 | RE: High memory usage [PATCH] |
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2001-06-20 05:05:50 | pg_xlog |
Previous Message | Grant | 2001-06-19 23:04:05 | Re: Sequence behaviour. |