roxdbcmd vacuumdb command
Hello,
The cron that is automatically created by the installer script does NOT shutdown the N1 database. Our weekly maintenance script that calls the vacuumdb command has always called cr_server stop first.
After some research, I have learned that without the DB running, the vacuumdb command will not work (nice to know). So, my question is, how does the cron work without shutting down the N1 DB and starting the postgress DB using : "> $./roxdbcmd pg_ctl start >roxdb.out 2>&1"?
I read an email from our freindly Sun PS person that read:
" There's also an experimental feature that we'd added in 5.1 to have
the MS carry out reindex and vacuum full during startup. It can be
enabled by setting the property app.dbm.invoke=true in the config.properties file for the MS and restarting it. The MS will do the vacuum full operation before it starts itself up. You can then later on remove this property to not have it invoke reindex & vacuum full every time it starts."
Is this still true in SPS 5.1? Or was that just a thought?
thanks,
Mike (in Santa Cruz)
