Become Platinium or Gold Neogia Partner

• Welcome
• Fonctionalities
  • Party
  • Product (Catalog)
  • CRM - SFA
  • Sale/Purchase(Shipmnt./Recpt.)
  • Point of Sales Terminal
  • Stock
  • Manufacturing
  • Quality
  • Services
  • Finance/Accounting
  • eCommerce
  • Business Intelligence
• Documentation
  • videos
  • User Documentation
  • Contributor Doc.
  • Project Documentation
  • Developer Doc.
  • Administrator Doc.
• Download
• Demo
• Organization
• Site Map

Updating Production Server

initialisation

• stop all server

stopofbiz.sh

Backup database and application program

• dump database:

pg_dump production > production.sql.`date +%d%m%y`

pg_dump integration > integration.sql.`date +%d%m%y`

• backup application program:

cp -a ofbizNeogia ofbizNeogia.`date +%d%m%y`

tar cjf ofbizNeogia.`date +%d%m%y`.tar.bz2 ofbizNeogia/

Update Integration application program

• update from cvs:

cvs up -dPr NEOGIA_versionNumber

• find and resolve cvs conflict:

cvs -nq update

Update database

• replace integration data by production data:

dropdb integration;
createdb integration;
psql integration < production.sql.ddMMYY; 

• compile and load seed data:

ant run-install-seed-fr

• start ofbizNeogia:

sh startofbiz.sh

• resolve database warning:
  • look at logs/console.log and fix warning database
• backup integration database

pg_dump integration > integration.sql.ddMMYY.versionNumber

test integration server

• start ofbizNeogia

sh startofbiz.sh

• perform test on integration

Update Production application program an databse

• update from cvs:

cvs up -dPr NEOGIA_versionNumber

• find and resolve cvs conflict:

grep ">>>>" * -R

• load integration database:

psql production < integration.sql.ddMMYY.versionNumber

• compile and load seed data:

ant 

• start ofbizNeogia

sh startofbiz.sh

• have a look at the log file and test if all is ok

Alter table public.W_RUN drop column CRQST_ID_NAME;