Difference between revisions of "Freeside:3:Documentation:Developer/bin/freeside-upgrade"
From Freeside
m (Edit via perl MediaWiki framework (1.13)) |
m (Edit via perl MediaWiki framework (1.13)) |
||
| Line 22: | Line 22: | ||
[ -s ]: Schema changes only. Useful for Pg/slony slaves where the data | [ -s ]: Schema changes only. Useful for Pg/slony slaves where the data | ||
| + | changes will be replicated from the Pg/slony master. | ||
[ -r ]: Skip sqlradius updates. Useful for occassions where the sqlradius | [ -r ]: Skip sqlradius updates. Useful for occassions where the sqlradius | ||
| Line 27: | Line 28: | ||
[ -c ]: Skip cdr and h_cdr updates. | [ -c ]: Skip cdr and h_cdr updates. | ||
| − | |||
| − | |||
[ -j ]: Run certain upgrades asychronously from the job queue. Currently | [ -j ]: Run certain upgrades asychronously from the job queue. Currently | ||
Latest revision as of 05:57, 10 February 2015
Contents
NAME
freeside-upgrade - Upgrades database schema for new freeside verisons.
SYNOPSIS
freeside-upgrade [ -d ] [ -q | -v ] [ -r ] [ -c ] [ -s ] [ -j ] [ -a ]
DESCRIPTION
Reads your existing database schema and updates it to match the current schema, adding any columns or tables necessary.
Also performs other upgrade functions:
- Calls FS:: Misc::prune::prune_applications (probably unnecessary every upgrade, but simply won't find any records to change); If necessary, moves your configuration information from the filesystem in /usr/local/etc/freeside/conf.<datasrc> to the database.
[ -d ]: Dry run; output SQL statements (to STDOUT) only, but do not execute
them.
[ -q ]: Run quietly. This may become the default at some point.
[ -v ]: Run verbosely, sending debugging information to STDERR. This is the
current default.
[ -s ]: Schema changes only. Useful for Pg/slony slaves where the data
changes will be replicated from the Pg/slony master.
[ -r ]: Skip sqlradius updates. Useful for occassions where the sqlradius
databases may be inaccessible.
[ -c ]: Skip cdr and h_cdr updates.
[ -j ]: Run certain upgrades asychronously from the job queue. Currently
used only for the 2.x -> 3.x cust_location, cust_pay and part_pkg
upgrades. This may cause odd behavior before the upgrade is
complete, so it's recommended only for very large cust_main, cust_pay
and/or part_pkg tables that take too long to upgrade.
[ -a ]: Run schema changes in parallel (Pg only). DBIx::DBSchema minimum
version 0.41 recommended. Recommended only for large databases and
powerful database servers, to reduce upgrade time.
