How to remove demo data from an already live and running application?

Question

I need to remove Your company and other demo data from an existing application without affecting the useful records.
The other company data should remain intact only demo data should be removed.

Keyur · Accepted Answer

Hi Sohail,

You should create new database without demo data instead removing demo data from existing database.

Andreas Fuchs · Answer

@avarcas.com Thanks for your answer helped me allot

Avarcas.com · Answer

You can use the following:

*Enter your VPS (if remote) or open terminal if in local:*
ssh -l root 99.99.99.99
*
*
*Use the postgres user:
*
➜  ~ su postgres
*Select database
*
➜ ~ psql abc_db_name
*And fire this operations in terminal:
*
delete from stock_pack_operation; delete from stock_picking; delete from stock_move; delete from account_invoice; delete from account_partial_reconcile; delete from account_move; delete from sale_order;  delete from account_payment;

iWesabe Technologies · Answer

I agree with  Keyur [1] .
**You never use demo database for business !!!
** Deleting demo data through postgres is *Not a proper way.*
Demo data will be restored if you install/upgrade a module.
Find the installed apps in existing database, create new one and install those.
Export all data in CSV/Xls and restore in new database.

[1] https://www.odoo.com/forum/help-1/user/17522

Bài viết liên quan	Trả lời	Lượt xem
After Load Data Demo demo_data	1 thg 6 25	1784
creation of company Đã xử lý company	1 thg 10 24	13217
Not able to create new company in live database in version 15 company	0 thg 10 22	2982
Is possible update value in exist demo data ? Đã xử lý demo_data	2 thg 3 22	13375
Function tag and getitem tag demo_data	2 thg 1 18	9302

Câu hỏi này đã bị gắn cờ

You never use demo database for business !!!

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!