| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: WAL details |
| Date: | 2004-04-28 04:01:03 |
| Message-ID: | 200404280401.i3S413H17636@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Simon Windsor wrote:
> Hi
>
> I want to be preserve a log of all SQL actions that change a database, (ie
> INSERT, UPDATE, DELETE, CREATE), to provide a full audit trail of the date,
> and to allow the recreation of a database at any time.
>
> I can achieve this wth ORACLE(recover and others) and MySQL(mysqlbinlog) quite
> easily. How do I achieve this with Postgres?
Use log_statement. In 7.5 you can log only data modification queries.
z
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-04-28 04:12:21 | Re: linked list rewrite |
| Previous Message | Tom Lane | 2004-04-28 03:55:09 | Re: Cannot open relation pg_cast_source_target_index |