| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | "Delao, Darryl W" <ddelao(at)ou(dot)edu>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [NOVICE] Postgres Syslog |
| Date: | 2003-03-28 21:40:47 |
| Message-ID: | 20030328214047.46996103C4@polaris.pinpointresearch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
That's a syslog issue, not a PostgreSQL issue. Read your syslog.conf man
pages. For many versions of syslog you use:
local3.*<tab>@host
instead of
local3.*<tab>/var/log/mylogfile
I just used local3 as an example - substitute the syslog facility name to
which you are routing your postgresql messages.
Remember that syslog expects tabs, not spaces between the facility/priority
and the destination (at least in all the syslogs I have used - check your man
pages).
Also be sure that the host is accepting remote syslog messages - most default
setups don't allow this. You will probably need to set a flag to allow remote
message logging.
Cheers,
Steve
On Friday 28 March 2003 8:26 am, Delao, Darryl W wrote:
> I am trying to setup the postgres.conf to send all postgres messages to a
> syslog server. However, in the conf file there is no place to define the
> host. I will be sending to an external host. How do I tell the conf file
> to send syslogs to an outside host?
>
> Thank you,
> Darryl
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fontenot, Paul | 2003-03-28 22:07:02 | Database files - personal curiosity |
| Previous Message | Guy Fraser | 2003-03-28 21:40:21 | Re: Realistic upper bounds on DB size |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NOFINWAY | 2003-03-28 23:05:01 | Monitor SQL Commands |
| Previous Message | brew | 2003-03-28 20:02:12 | Re: Insert fails from VB only when table is empty...? |