RE: [GENERAL] Transaction logging

This is a great idea. I have not been successful in tracking any
information on syslog. Any suggestions on where I might find some good
documentation on syslog?

-----Original Message-----
From: Peter T Mount [SMTP:peter(at)retep(dot)org(dot)uk]
Sent: Tuesday, February 23, 1999 3:40 AM
To: Michael Davis
Cc: 'pgsql-general(at)postgreSQL(dot)org'
Subject: Re: [GENERAL] Transaction logging

On Mon, 22 Feb 1999, Michael Davis wrote:

> Has anyone implemented transaction logging in Postgres? Any
suggestions on
> how to easily implement transaction logging? Storing the log file
in a text
> file seems best but I am not sure out to open and write to a text
file from
> a trigger. I would also be nice to post this transaction log
against a back
> up server.

Just a quick thought, but how about using syslog? That can be used
to post
queries to a remote server, and it can be told to store the
"postgres"
stuff to a seperate file on that server.

Just an idea...

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf