Re: [SL] Moving SQL Ledger from one System to another

[Paul T. <pt...@wa...>]

I suggest to start a new company named test and same user as in live db as a
user.
Then:

su postgres
psql test < backup.sql

login test

I use a test firm to try everything. From invoice numbering to reports, from
stock and inventory to year-end.
Feels safer that way, and if it works in test, the chances of ruining the
real maccoy are slim.

That way the test data is clearly markeds as such, test. Fine for testing
and employee training.

I sure hope nobody is tempted to copy over testdata to the real database.
Seems certifiable ;-)

2008/1/29, lh...@pa... <lh...@pa...>:
>
> See I already have a secure openvpn tunnel to the office.
> But my problem was letting her "try" things on the "live"
> data. That is why I wanted to bring the data from the office
> to the home. So that way she can play with the system and
> I do not have to worry about anything.
>
> Now Do I have to do
>
> create a blank database and restore the data.
>
> psql -U sql-ledger -c "create database newdb;" template1
> psql -U sql-ledger newdb < backup.sql
>
> with the backup file on the home system ?
>
> And does "newdb" have to be the same name as the one from the store ?
>
> Thanks
>
> Steven L'Heureux
>
> > Why not create a secure but remote login?
> > She can then enter anything she wants in the real database.
> >
> > Just remember to backup, preferably also remote (email to different
> > locations is a smart bet).
> >
> > Two databases in two locations sounds like an accident waiting to
> happen..
> >
> > 2008/1/29, lh...@pa... <lh...@pa...>:
> >>
> >> Basicly it's just so she can learn how to input everything now.
> >> Not just her daily sales. All her expenses, reciepts and such.
> >> So I want to bring an up to date copy of her data home and
> >> import it there so she can do work on it so she does not mess
> >> anything up.
> >>
> >> Steven L'Heureux
> >>
> >>
> >> > On 火, 2008-01-29 at 09:29 -0500, lh...@pa... wrote:
> >> >> How and what is the prefered method for moving
> >> >> my SQL Ledger Data from my wife's work to her
> >> >> home office?
> >> >>
> >> >> Systems are using Fedora.
> >> >
> >> > One-time thing? If so, do System -> Backup -> Save to file, copy the
> >> > file to the other system, and do restore as explained in the manual.
> >> > That will back up the data base. You should probably tar up and copy
> >> > over the users/ directory.
> >> > --
> >> > Stuart Luppescu -=- slu .at. ccsr.uchicago.edu
> >> > University of Chicago -=- CCSR
> >> > 才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r3
> >> > There is no time like the present for postponing
> >> >  what you ought to be doing.
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> -------------------------------------------------------------------------
> >> > This SF.net email is sponsored by: Microsoft
> >> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> >> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >> > _______________________________________________
> >> > sql-ledger-users mailing list
> >> > sql...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >>
> -------------------------------------------------------------------------
> >> This SF.net email is sponsored by: Microsoft
> >> Defy all challenges. Microsoft(R) Visual Studio 2008.
> >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >>
> >
> -------------------------------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > !DSPAM:11,479f77a446224379617435!
> >
> >
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>