Hi Louis,
On Tue, Sep 16, 2014 at 7:26 PM, Louis <lbml...@hethcote.com> wrote:
>
> Is there a tool for copying a production lsmb db into a fresh development
> db.
>
>
Yes, with setup.pl you can copy your production database to a new database
which you can use to test/develop your business. One remark applies: roles
are shared between prodution and development system.
> Or does:
> pg_dump --format=tar proddb > ./proddb.pg
> pg_restore --clean --create --format=tar --dbname=testdb ./proddb.pg
>
> do the trick
>
even faster: createdb -T proddb testdb
:-)
--
Bye,
Erik.
http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce.
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
