| From: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | WAL details |
| Date: | 2004-04-27 20:07:49 |
| Message-ID: | 200404272107.49284.simon.windsor@cornfield.org.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
Simon
--
Simon Windsor
Eml: simon(dot)windsor(at)cornfield(dot)org(dot)uk
Tel: 01454 617689
Mob: 07960 321599
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Mailscanner thanks transtec Computers for their support.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-04-27 20:47:01 | Re: [HACKERS] TPC H data |
| Previous Message | Ron St-Pierre | 2004-04-27 19:20:51 | Re: composite type and assignment in plpgsql |