Re: How to erase transaction logs on PostgreSQL - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: How to erase transaction logs on PostgreSQL
Date
Msg-id 1331223817.2322.12.camel@localhost.localdomain
Whole thread Raw
In response to How to erase transaction logs on PostgreSQL  (Frank Church <voipfc@gmail.com>)
Responses Re: How to erase transaction logs on PostgreSQL
List pgsql-general
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


pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: FDWs, foreign servers and user mappings
Next
From: Merlin Moncure
Date:
Subject: Re: [BUGS] Altering a table with a rowtype column