Thread: 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.
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 logsI 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