Thread: Postgres Syslog
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
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@postgresql.org
How about sending log messages to a single file. I see a file under var/log called pgsql, but it has nothing in it. What do I need to enable in the postgreql.conf to start logging to a local file? Thanks, Darryl -----Original Message----- From: Steve Crawford [mailto:scrawford@pinpointresearch.com] Sent: Friday, March 28, 2003 3:41 PM To: Delao, Darryl W; 'pgsql-novice@postgresql.org'; 'pgsql-general@postgresql.org' Subject: Re: [NOVICE] Postgres Syslog 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@postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Hi, On Mon, 31 Mar 2003, Delao, Darryl W wrote: > How about sending log messages to a single file. I see a file under var/log > called pgsql, but it has nothing in it. What do I need to enable in the > postgreql.conf to start logging to a local file? Start PostgreSQL with -l parameter: pg_ctl .... -l /var/log/pgsql If you are using an rpm-based installation; edit the init script of PostgreSQL (usually under /etc/init.d) and add -l parameter to start line, i.e. su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -l /var/log/pgsql -D $PGDATA -p /usr/bin/postmaster start > /dev/null 2>&1" < /dev/null Regards, -- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.gunduz.org
On Fri, Mar 28, 2003 at 10:26:40AM -0600, 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? You don't. Rather, you tell it to send to some specific facility, and the configure your syslogd to send it to a remote host. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "I think my standards have lowered enough that now I think 'good design' is when the page doesn't irritate the living fuck out of me." (JWZ)
On Monday 31 March 2003 09:02, Delao, Darryl W wrote: > How about sending log messages to a single file. I see a file under > var/log called pgsql, but it has nothing in it. What do I need to enable > in the postgreql.conf to start logging to a local file? You do this in the _syslog_ configuration, not in the PostgreSQL configuration. That is just the way syslog works: PostgreSQL contacts the local syslogd, and logs its message using the syslog facility you define in postgresql.conf. What syslog does with that message is determined by /etc/syslog.conf. That could be any one of all sorts of things, including, but not limited to, logging to a single file, logging to a remote syslog server, logging to the system console, logging to a printer, etc.....and it's all controlled in /etc/syslog.conf. So 'man syslog.conf' and see what you need to do. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11