Creating Ledgersmb Database Live & Test Environments

Written by James McDonald

December 17, 2009

Warning: This setup can be dangerous if you forget which environment you are in you can cause damage to your LIVE environment.

Login to postgres as a superuser and use \l to list your databases

me@lsmbbox:~$ psql -U ledgersmb -h localhost
Password for user ledgersmb: 
Welcome to psql 8.3.8, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

ledgersmb=> \l
            List of databases
       Name       |   Owner   | Encoding 
 jmits-5zero-live | ledgersmb | UTF8
 ledgersmb        | ledgersmb | UTF8
 postgres         | postgres  | UTF8
 template0        | postgres  | UTF8
 template1        | postgres  | UTF8
(5 rows)

Identify your ledgersmb database. Mine is jmits-5zero-live

backup your live DB using pg_dump

me@lsmbbox:~$ pg_dump -U ledgersmb -h localhost jmits-5zero-live  > jmits-5zero-live.sql

Create a new test database

createdb -T ledgersmb jmits-5zero-test

Restore you live backup into the test db

psql -U ledgersmb -h localhost jmits-5zero-test < jmits-5zero-live.sql 

Goto the ledgersmb admin page and login

Configure your user account to use the test db

Always check your environment when logging in to LedgerSMB and clicking the Version Link in the left hand side to display your DB environment:


Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…