Rotating PostgreSQL LOGs on Web site ??

I think the general solution is to compile with syslog support and use
the normal syslog rotation scripts.

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?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026