One of our clients started with LedgerSMB just a few weeks ago. They have been "practicing" with LedgerSMB, and now they'd like to really start using it. They would like us to clear the database of transactions, orders, etc. Deleting rows in the database is problematic since there are constraints and an audit trail. Instead, I created a database that's just schema from the original database. When I run setup.pl, it can't deal with the database:
Logged in as postgresUnknown database found.Cancel?
The best thing to do to create a new database using the setup.pl and backup without permissions. You can then restore just that database.
The thing that is missing in your case is the set of rows in the defaults table, but there may be other stuff you'd like to move over, like charts of accounts and the like.
Minimally:
INSERT INTO defaults (setting_key, value) VALUES ('version', '1.3.0');
Note that you will still need to set up defaults, charts of accounts, etc.
Best Wishes,
Chris Travers
Thanks.
Brian
Brian WolfPhone: 410.367.2958Email: ..hidden..Try out Activus Secure Payments™, our recurring payments application.Demo at http://demo.activustech.com
------------------------------------------------------------------------------
Keep yourself connected to Go Parallel:
DESIGN Expert tips on starting your parallel project right.
http://goparallel.sourceforge.net/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
