Re: Problems logging in - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: Problems logging in
Date
Msg-id 20060423025119.650.qmail@web31815.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Problems logging in  (John Oliver <joliver@john-oliver.net>)
Responses Re: Problems logging in
List 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,



pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Performance
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Automatically assuming a specific role after connecting