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

Re: [GENERAL] Transaction logging

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
Cc: "'pgsql-general(at)postgreSQL(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Transaction logging
Date: 1999-02-23 10:39:47
Message-ID: Pine.LNX.4.04.9902231038290.14860-100000@maidast.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

Responses

pgsql-general by date

Next:From: Stéphane DupilleDate: 1999-02-23 13:07:40
Subject: Re: [GENERAL] Transaction logging
Previous:From: K.T.Date: 1999-02-23 10:18:00
Subject: Re: [GENERAL] Copy a database.

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