Thread: postgres logs

postgres logs

From
"Chris"
Date:
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.

Re: postgres logs

From
"Matt Lynch"
Date:
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  http://www.postgres.org/docs/current/static/runtime.html

Regards,

Matt

 

-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Chris
Sent: Monday, December 22, 2003 11:00 AM
To: pgsql-novice@postgresql.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