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.

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
[mailtogsql-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