Skip site navigation (1) Skip section navigation (2)

RE: [GENERAL] Transaction logging

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: "'pgsql-general(at)postgreSQL(dot)org'" <pgsql-general(at)postgreSQL(dot)org>
Subject: RE: [GENERAL] Transaction logging
Date: 1999-02-23 15:26:19
Message-ID: 93C04F1F5173D211A27900105AA8FCFC1451D8@lambic.prevuenet.com (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: Jim MercerDate: 1999-02-23 15:39:44
Subject: Re: [GENERAL] Transaction logging
Previous:From: St├ęphane DupilleDate: 1999-02-23 13:07:40
Subject: Re: [GENERAL] Transaction logging

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group