| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Kamil Srot" <kamil(dot)srot(at)nlogy(dot)com> |
| Cc: | "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tables dissapearing |
| Date: | 2007-08-27 22:48:58 |
| Message-ID: | dcc563d10708271548q7bcea4f3v2c49c8324d8d28d7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8/27/07, Kamil Srot <kamil(dot)srot(at)nlogy(dot)com> wrote:
> I really need to make sure, the next problem (if it's necessary to let
> it happen) will be the last one... :-(
Have you set your log_statement to 'ddl' in postgresql.conf?
That way you'll have a log of every single ddl that goes through the
database. At least then when the table disappears again you can look
in your logs to see if it was in fact a client app that did it.
Also, look at taking away permission from anyone BUT the postgres
superuser to drop objects.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-27 22:58:47 | Re: Detecting whether a point is in a box. |
| Previous Message | Tom Lane | 2007-08-27 22:41:01 | Re: psql \copy command runs as a transcation? |