From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | John Oliver <joliver(at)john-oliver(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problems logging in |
Date: | 2006-04-23 02:51:19 |
Message-ID: | 20060423025119.650.qmail@web31815.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Is whitespace important? Tabs? The number of spaces?
> Ohhhkaaaayyy... so, what settings would be needed to get usable logs?
> Set everything that has "log" in the name to "true"?
--postgresql.conf
redirect_stderr = true
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_rotation_size = 10240
log_min_messages = info
log_line_prefix = '%t%%%d '
These are the setting in my conf file.
Also, when start postgresql:
This page is a good source for capturing postmaster messages
http://www.postgresql.org/docs/7.4/interactive/postmaster-start.html
pg_ctl start -D /usr/local/pgsql/data -l serverlog
serverlog is the name and location of would you want postmaster logs.
check your /ect/init.d/ script and /etc/conf.d/ conf for adding this functionality.
Regards,
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-04-23 04:01:51 | Re: [GENERAL] Transaction eating up all RAM |
Previous Message | John Oliver | 2006-04-23 02:05:14 | Re: Problems logging in |