In response to "Pradeepa" <pradeepa.ili@valtech.co.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@collaborativefusion.com
Phone: 412-422-3463x4023