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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
