Skip to main content

How do I unset the SyslogFacility Parameter?

  • September 20, 2013
  • 1 reply
  • 5 views
Alec_Isaacson
The 6.1 admin guide says that the SyslogFacility system parameter will override the standards that Vertica uses. The docs seem to say the setting will force all log entries to be posted under whatever SyslogFacility is set to. I've set that option, but now want to "un-set" it so Vertica goes back to its out of the box behavior. My problem is that I don't see how to do that. Can anyone help?

    1 reply

    Prasanta_Pal
    Forum|alt.badge.img
    • Prasanta_Pal
    • Participating Frequently
    • September 21, 2013
    Check first what is set and then change it to default by checking what is the default value from the second query see below: dbadmin=> SELECT GET_CONFIG_PARAMETER('SyslogFacility'); GET_CONFIG_PARAMETER ---------------------- user (1 row) dbadmin=> select * from configuration_parameters where parameter_name = 'SyslogFacility'; node_name | parameter_name | current_value | default_value | change_under_support_guidance | change_requires_restart | description -----------+----------------+---------------+---------------+-------------------------------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ALL | SyslogFacility | user | user | f | f | auth, uucp, authpriv (Linux only) local0, cron, local1, daemon, local2, ftp (Linux only) local3, lpr, local4, mail, local5, news, local6, user (default system) local7 (1 row)
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement