Re: How to erase transaction logs on PostgreSQL

On Fri, 2012-03-09 at 00:09 +0000, Frank Church wrote:
> 
> 
> On 8 March 2012 16:23, Guillaume Lelarge 
> wrote:
>         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).
>         
>         
> 
> What are the commands to accomplish that, ie getting PostgreSQL to
> erase the logs?
> 

PostgreSQL doesn't erase logs. You need to do it yourself, either
manually or with a script (executed by cron for example).


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