Re: How to erase transaction logs on PostgreSQL

On 03/08/12 4:09 PM, Frank Church wrote:
> What are the commands to accomplish that, ie getting PostgreSQL to
> erase the logs?

there's two completely different sorts of logs here. 'transaction
logs' in postgres are the write-ahead logs, these are binary files used
internally by postgres, in the pg_xlog directory, as Simon said, you can
use pg_resetxlog() to 'reset' the state of this.

the other sort of logs are the human readable log files, generated for
debugging and auditing purposes, these contain just what you configure
them to contain, and are often stored in pg_log, or in the system logs
(/var/log/...) depending on your configuration. you'd have to delete
these yourself outside of postgres.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast