Thread: loggin

Hi,

I compiled postgres with the --with-syslog option.  Will this logging
happen when you do not otherwise specify a log location at startup?  I
couldn't find any logging happening in /var/log/messages.  Is this where
it happens?

I'm also wondering about the significance of specifying a pid location in
the startup script.  Why do you do this?  I haven't been and the only
problem I have seend is pg_ctl can't find the pid and I have to use the
/etc/rc.d/init.d/postgresql to start/stop (using red hat)

Culley

"culley" wrote:
  >I compiled postgres with the --with-syslog option.  Will this logging
  >happen when you do not otherwise specify a log location at startup?  I
  >couldn't find any logging happening in /var/log/messages.  Is this where
  >it happens?

--with-syslog includes the code that lets logging happen but does not of
itself enable logging.  You have to turn that on with an option in
postgresql.conf.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "But be ye doers of the word, and not hearers only,
      deceiving your own selves."              James 1:22

>>>>> "c" == culley  <culley@easystreet.com> writes:

c> I compiled postgres with the --with-syslog option.  Will this logging
c> happen when you do not otherwise specify a log location at startup?  I
c> couldn't find any logging happening in /var/log/messages.  Is this where
c> it happens?

Postgres will log using the facility you tell it, usually "local0".
You need to arrange to have syslog put those messages into some file.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/