Re: database copy tool

[Erik Huelsmann <..hidden..>]

Hi Louis,

On Tue, Sep 16, 2014 at 7:26 PM, Louis <..hidden..> 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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users