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é
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 |