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