Re: Problems logging in

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,

In response to

Responses

Browse pgsql-general by date

  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