| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stéphane Dupille | 1999-02-23 13:07:40 | Re: [GENERAL] Transaction logging |
| Previous Message | K.T. | 1999-02-23 10:18:00 | Re: [GENERAL] Copy a database. |