| From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
|---|---|
| To: | "Pradeepa" <pradeepa(dot)ili(at)valtech(dot)co(dot)in> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Reg : Data base deletion |
| Date: | 2008-06-25 12:06:22 |
| Message-ID: | 20080625080622.6016fe4d.wmoran@collaborativefusion.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
In response to "Pradeepa" <pradeepa(dot)ili(at)valtech(dot)co(dot)in>:
>
> We want some information like, if any one deletes database from postgres,
> how to trace when it has been deleted.
The easiest way that I know of is to enable logging of DDL statements in
postgresql.conf. Make sure you have enough disk space to handle all
the log data that results.
> The deletion is not from any command
> but by right clicking on db and deleting it.
It doesn't matter. Whatever GUI you're using to do this will simply
convert your clicking into SQL commands, so it's really the same
thing from the server's perspective.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2008-06-25 12:26:51 | Re: Reg : Data base deletion |
| Previous Message | Russell Smith | 2008-06-25 09:00:21 | libpq does not manage SSL callbacks properly when other libraries are involved. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2008-06-25 12:19:08 | Re: pg_dump estimation |
| Previous Message | Allan Kamau | 2008-06-25 12:03:53 | Re: pg_dump estimation |