Re: How to erase transaction logs on PostgreSQL

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: voipfc(at)gmail(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to erase transaction logs on PostgreSQL
Date: 2012-03-08 16:23:37
Message-ID: 1331223817.2322.12.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-03-08 17:08:36 Re: [GENERAL] Altering a table with a rowtype column
Previous Message Achilleas Mantzios 2012-03-08 15:52:41 Re: How to erase transaction logs on PostgreSQL