Search Postgresql Archives

Re: Problems logging in

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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,




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux