[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: database copy tool

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

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




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.
Ledger-smb-users mailing list