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
"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/
"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