Delete ALL Data

Delete ALL OrderTrac data & start fresh

If you want to remove all current data from OrderTrac and start with a blank slate, just like it was when you first downloaded OrderTrac, then follow these steps:

 Warning! ALL DATA (preferences, customers, invoices, items, vendors, EVERYTHING!) will be deleted FOREVER! 

  1. Open the database administration tool from the following location: Start > All Programs > PostgreSQL 9.3 > pgAdminIII
  2. Double click ‘PostgreSQL 9.3 (localhost:5432)’ to open the database server.
  3. Click the ‘+’ by ‘Databases’
  4. You should see at least 2 databases: ordertrac and postgres
  5. Click ‘postgres’
  6. Click the Tools menu at the top and select ‘Query Tool’
  7. Enter the following:
  8. SELECT pg_terminate_backend(pg_stat_activity.pid)FROM pg_stat_activity
    WHERE pg_stat_activity.datname ='ordertrac'
      AND pid <> pg_backend_pid();
    
  9. Click the Execute Query button (Green triangle on the toolbar)
  10. Close the Query Tool
  11. Now right click ‘ordertrac’ under ‘Databases’.
  12. Click ‘Delete/Drop…’
  13. Click Yes

Ordertrac Database has now been deleted. The next time you open OrderTrac, all data will be deleted!