Skip site navigation (1) Skip section navigation (2)

Re: Reg : Data base deletion

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

In response to

Responses

pgsql-bugs by date

Next:From: Andrew SullivanDate: 2008-06-25 12:26:51
Subject: Re: Reg : Data base deletion
Previous:From: Russell SmithDate: 2008-06-25 09:00:21
Subject: libpq does not manage SSL callbacks properly when other libraries are involved.

pgsql-general by date

Next:From: Bill MoranDate: 2008-06-25 12:19:08
Subject: Re: pg_dump estimation
Previous:From: Allan KamauDate: 2008-06-25 12:03:53
Subject: Re: pg_dump estimation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group