Rotating PostgreSQL LOGs on Web site ??

From: Hervé Piedvache <herve(at)elma(dot)fr>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Rotating PostgreSQL LOGs on Web site ??
Date: 2001-10-12 17:56:13
Message-ID: 3BC72EBD.BCBB04E7@elma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm interesting to know how to find a solution for rotating the
PostgreSQL log file ...

I'm usgin thoses options for the log generated :
silent_mode = false
log_connections = false
log_timestamp = true
log_pid = false
debug_level = 2 # range 0-16
debug_print_query = false
debug_print_parse = false
debug_print_rewritten = false
debug_print_plan = false
debug_pretty_print = false

BUT I have in 13 days a log file of 12 Gb ...

The big trouble is ... that is a web site Database ...
So It's IMPOSSIBLE for me to STOP the database ... or finding a solution
to not loose my members subscribing ...

And if I stop PostgreSQL ... I'll have also to restart the Apache
servers wich are connected to the database ... and that's mean really
good cron timing ...

So if you have any ideas about that ... I'll be so pleased for your help
!!

Regards,
--
Hervé

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hervé Piedvache 2001-10-12 17:56:40 Vacuum analyze with 7 millions records ... takes 1 hour !
Previous Message curtis 2001-10-12 17:50:26 triggers, rules, visibility, and synchronization woes