<< Bsvfollowers | Index | Delete Fachinfo >>

If you run FI-Import and BAG-XML-Import at the same time, you will probably have to do this (even if you run the imports form two different jobs)

• Turn off the services

ywesee@thinpower /service $ svc -d ch.oddb
thinpower service # svc -d ch.oddb-readonly
thinpower service # svc -d ch.oddb-exporter
thinpower service # svc -d ch.oddb-fiparse
thinpower service # svc -d ch.oddb-meddata
thinpower service # svc -d ch.oddb-swissindex_nonpharma
thinpower service # svc -d ch.oddb-swissindex_pharma
thinpower service # svc -d ch.oddb-swissreg
thinpower service # svc -d currency

• Drop database

 # sudo -u postgres dropdb oddb.org.ruby193

• Create database

 # sudo -u postgres createdb -E UTF8 -T template0 oddb.org.ruby193

• Restore database

 # zcat 22\:00-postgresql_database-oddb.org.ruby193-backup.gz | psql -U oddb.org.ruby193

• Restart services