Re: Reg : Data base deletion

In response to "Pradeepa" <pradeepa.ili@[EMAIL PROTECTED]
>:
> 
> 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@[EMAIL PROTECTED]
 412-422-3463x4023

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs