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

[<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 $B2P(B, 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
>> > $B:MJ8$HCRF`H~$NIc(B -=-    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!
>
>