Re: 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