From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: postgres, syslog and freeBSD
Date: Fri, 30 May 2008 09:04:27 +0300
User-Agent: KMail/1.9.7
Cc: kevin kempter <kevin@kevinkempterllc.com>
References: <0AF6C4FA-FC04-4AC1-8603-7E5596301F62@kevinkempterllc.com>
In-Reply-To: <0AF6C4FA-FC04-4AC1-8603-7E5596301F62@kevinkempterllc.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200805300904.28630.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Friday 30 May 2008 07:35:19 =CE=BF/=CE=B7 kevin ke=
mpter =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hi list;
>=20
> I'm trying to get postgres & syslog to get along with no luck. I'm =20
> running freeBSD7 and postgres 8.3.1
>=20
> Here's my postgres setup
>=20
> log_destination =3D 'syslog'
> #logging_collector =3D off
> syslog_facility =3D 'LOCAL0'
> syslog_ident =3D 'postgres'
> silent_mode =3D on
> log_min_duration_statement =3D 0
>=20
>=20
> Here's my /etc/syslog.conf file:
>=20
>=20
> security.*					/var/log/security
> auth.info;authpriv.info				/var/log/auth.log
> mail.info					/var/log/maillog
> lpr.info					/var/log/lpd-errs
> ftp.info					/var/log/xferlog
> cron.*						/var/log/cron
> *.=3Ddebug					/var/log/debug.log
> *.emerg						*
> # uncomment this to log all writes to /dev/console to /var/log/=20
> console.log
> #console.info					/var/log/console.log
> # uncomment this to enable logging of all log messages to /var/log/=20
> all.log
> # touch /var/log/all.log and chmod it to mode 600 before it will work
> #*.*						/var/log/all.log
> # uncomment this to enable logging to a remote loghost named loghost
> #*.*						@loghost
> # uncomment these if you're running inn
> # news.crit					/var/log/news/news.crit
> # news.err					/var/log/news/news.err
> # news.notice					/var/log/news/news.notice
> !startslip
> *.*						/var/log/slip.log
> !ppp
> *.*						/var/log/ppp.log
> LOCAL0.*					/var/log/pgsql

change that to

local0.*                                        /var/log/pgsql.log

(lowercase, also a .log suffix is more standard)
make sure the /var/log/pgsql.log file exists (create it with vi),
and then change its permissions to smth like
=2Drw-------  1 root  wheel  109274 30 =CE=9C=CE=B1=CF=8A 09:00 /var/log/pg=
sql.log

This works in my FreeBSD system, although with 7.4.*, i dont have any 8.3.1=
 handy at the moment.
>=20
>=20
>=20
> I dont see any files show up in /var/log
>=20
> what am I doing wrong?
>=20
> Thanks in advance..
>=20
> /Kevin
>=20
>=20


=2D-=20
Achilleas Mantzios