Search Postgresql Archives

Re: Tables dissapearing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 8/27/07, Kamil Srot <kamil.srot@xxxxxxxxx> 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.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux