Patch applied. Thanks. ---------------------------------------------------------------------------
Ray Aspeitia wrote: > Hello, > > I wanted to submit some changes to the bundled postgres startup > script for Mac OS X. I added calls to utilize the bundled apache > rotatelogs script in the DB startup for log rotation. Also modified > startup parameters file to allow using the "SystemStarter" utility to > start/stop/restart postgres with a rotating log file. > > The script credits David Wheeler, 2002. I wrote him a message about > the changes an he suggested I post them here. I explain some of the > changes below. > > Not sure how to submit the changes. I have 3 files, "PostgreSQL" > script, "StartupParameters.plist" file, "pg_startupscript.diff" file. > The diff file was run against the original "PostgreSQL" script file. > I'll try attaching them to this message. If they get filtered I can > resend if needed. > > Thanks. > > Ray A. > > > ------------------------------------ > > 1) Changed the "Provides" parameter in StartupParameters.plist to > "PostgreSQL" from "postgres database" simply for ease of typing. It > seems that the SystemStarter utility uses the "Provides" value if you > want to control the script. This way I did not have to enclose it in > quotes on commandline. The modified StartupParameters.plist is now an > XML document also. > > > 2) For the startup script I added 2 user modifiable variables: > > # do you want to rotate the log files, 1=true 0=false > ROTATELOGS=1 > > # logfile rotate in seconds > ROTATESEC="604800" > > I also added a non modifiable variable: > > # The apache log rotation utility > LOGUTIL="/usr/sbin/rotatelogs" > > I modified the StartService and RestartService functions to execute > the new commands if the user wants log rotation. [ Attachment, skipping... ] [ Attachment, skipping... ] [ Attachment, skipping... ] [ Attachment, skipping... ] [ Attachment, skipping... ] [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster