one ultra dummy way would be to dump, back up, destroy the data dirs, and any human /var/log files and then re-initdb and restore. On Πεμ 08 Μαρ 2012 12:18:17 Frank Church wrote: > How do you purge the postgresql transaction log? > > 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? > > /voipfc -- Achilleas Mantzios IT DEPT -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general