Re: How to erase transaction logs on PostgreSQL

On Thu, 2012-03-08 at 10:18 +0000, Frank Church wrote:
> How do you purge the postgresql transaction log?
>

You don't. PostgreSQL does it for you.

> I am creating a virtual machine image and I want to erase any transaction
> logs that got built up during development. What is the way to do that?
>
> I am currently using 8.3 and 8.4.
>
> Is there the possibility that the logs saved in /var/log also contain
> security details?
>

The only security detail AFAIK would be passwords (if you set a password
and log queries, the password will be in the logs... the only way to
prevent that is to send it crypted).


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com