On Sat, Dec 1, 2012 at 5:21 PM, Brian Wolf <br...@activustech.com> wrote:
> 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 postgres
> Unknown 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.
>
> What must be changed or added to the database so setup.pl will recognize
> it?
>
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 Wolf
> Phone: 410.367.2958
> Email: br...@activustech.com
> 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
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
<<activus_logo_small.png>>
------------------------------------------------------------------------------ Keep yourself connected to Go Parallel: BUILD Helping you discover the best ways to construct your parallel projects. http://goparallel.sourceforge.net
_______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
