Re: postgres logs

HI Chris,

You can specify the log file with the -l option
e.g.
pg_ctl start -l c:\psql.log

You can also configure what goes into the log with options

e.g.
pg_ctl start -l c:\psql.log -o "-d16 -D C:\postgis\data -c
MAX_CONNECTIONS=yes -c DEBUG_PRINT_PARSE=yes -c LOG_PID=yes -c
LOG_TIMESTAMP=yes -c LOG_CONNECTIONS=yes -c SHOW_PARSER_STATS=yes -c
STATS_COMMAND_STRING=yes"

You will find details on the options in Chap 16 of the manual HYPERLINK
"http://www.postgres.org/docs/current/static/runtime.html"http://www.pos
tgres.org/docs/current/static/runtime.html

Regards,

Matt

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Chris
Sent: Monday, December 22, 2003 11:00 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] postgres logs

I was wondering if postgres generates any logs. If so where are they. Or
does it have to be told to make them. If this is the case what do i have
to do to do that.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003