Re: Syslog Facility Patch - Mailing list pgsql-hackers

* Larry Rosenman <ler@lerctr.org> [001114 14:44]:
> * Peter Eisentraut <peter_e@gmx.net> [001114 14:39]:
> > Larry Rosenman writes:
> > 
> > > * Peter Eisentraut <peter_e@gmx.net> [001114 13:18]:
> > > > Larry Rosenman writes:
> > > > 
> > > > > > I can't reproduce that.  I set 'syslog_facility = local97' and got the
> > > > > > right error message.
> > > > > try setting it in postgresql.conf....
> > > > 
> > > > That's what I did.
> > > Hmm.  Here is what I get: 
> > > $ ../bin/pg_ctl -D ~/pg-test/data -o "-p 7777 -i" start
> > > postmaster successfully started up.
> > > $ FATAL 1:  postgresql.conf:17: syntax error
> > 
> > Check that you have a newline at the end of the file.
> I do.  If I put the correct value all works fine (I took the
> sample and edited it).
> 
> "postgresql.conf" 25L, 685C [w]
> Thanks for using Vim 507 . --Sven Guckes@vim.org!
> $ pwd
> /home/ler/pg-test/data
> $ cd ..
> $ bin/pg_ctl -D ./data -o "-p 7777 -i" start
> postmaster successfully started up.
> $ FATAL 1:  postgresql.conf:17: syntax error
> 
> $ cat data/postgresql.conf
> #
> # PostgreSQL configuration file
> # -----------------------------
> #
> # This file consists of lines of the form
> #
> #   name = value
> #
> # (The `=' is optional.) White space is collapsed, comments are
> # introduced by `#' anywhere on a line. The complete list of option
> # names and allowed values can be found in the PostgreSQL
> # documentation. Examples are:
> 
> log_connections = on
> fsync = off
> #max_backends = 64
> syslog_facility = LOCAL5.3we4rwjtasrtuert
> syslog_progid = pgtest
> syslog=2
> showportnumber = on
> 
> # Any option can also be given as a command line switch to the
> # postmaster, e.g., `postmaster --log-connections=on'. Some options
> # can be set at run-time with the `SET' SQL command.
> 
> $
> > 
> > -- 
> > Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
Interestingly, on my FreeBSD box:
$ ../bin/pg_ctl -D ~/pg-test/data -o "-p 7777 -i" start
postmaster successfully started up.
$ FATAL 1:  invalid value for option 'syslog_facility':
'LOCAL112oieq4u2345'

$ uname -a
FreeBSD lerbsd.lerctr.org 4.2-BETA FreeBSD 4.2-BETA #82: Sun Nov 12
16:57:22 CST2000     ler@lerbsd.lerctr.org:/usr/src/sys/compile/LERBSD  i386
$

This looks like a portability issue.  The other stuff I sent was
from UnixWare 7.1.1 using native cc. 

LER

> 
> -- 
> Larry Rosenman                      http://www.lerctr.org/~ler
> Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
-- 
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749