Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres logs - Mailing list pgsql-novice

From Matt Lynch
Subject Re: postgres logs
Date
Msg-id 001d01c3c8b7$676134e0$d701a8c0@matt
Whole thread Raw
In response to postgres logs  ("Chris" <codle@valuelinx.net>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: "Chris"
Date:
Subject: postgres logs
Next
From: "Stephen Shorrock"
Date:
Subject: pl/pgSQL sequence question