Menu
▾
▴
sql-ledger-users
|
From: <lh...@pa...> - 2008-01-29 14:57:21
|
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 > > !DSPAM:11,479f3d5e136532958492736! > > |
|
From: <lh...@pa...> - 2008-01-29 21:45:28
|
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! > > |
|
From: Adam V. <amv...@gm...> - 2008-01-29 21:51:20
|
Another option which we do is create a new dataset in the existing SL installation, then restore a current backup to the new dataset and then have your new user use the test dataset. Easy to update and restore if there's a screwup and you've avoided running multiple installations of SL. > 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! >> >> >> > > > > ------------------------------------------------------------------------- > 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 > > -- Adam Vandemore Systems Administrator IMED Mobility |
|
From: Bob G. <bo...@rc...> - 2008-01-30 05:06:15
|
As long as she understands that it is just a training system at home and the information she keys into her home system will NOT be imported back into the office system (this is where the problems can occur..), just set up the home system with a copy of the office system. The temptation will be to 'save some keystrokes' and attempt to import the newly keyed data in the home system back into the live office system. Good Luck Bob G On Tue, 2008-01-29 at 15:50 -0600, Adam Vandemore wrote: > Another option which we do is create a new dataset in the existing SL > installation, then restore a current backup to the new dataset and then > have your new user use the test dataset. Easy to update and restore if > there's a screwup and you've avoided running multiple installations of SL. > > 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! > >> > >> > >> > > > > > > > > ------------------------------------------------------------------------- > > 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 > > > > > > |
|
From: Paul T. <pt...@wa...> - 2008-01-30 07:07:28
|
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 > > |
|
From: Luke <acc...@li...> - 2008-01-30 07:17:19
|
Why don't you just create a test company for her on the office database = server? Let her work with that, like one of the test versions on = sql-ledger's web site. On Tue, 29 Jan 2008, = lh...@pa... wrote: > 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 happe= n.. > > > > 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 =B2=D0, 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 -=3D- slu .at. ccsr.uchicago.edu > >> > University of Chicago -=3D- CCSR > >> > =BA=CD=CA=B8=A4=C8=C3=D2=C6=E0=C8=FE=A4=CE=C9=E3 -=3D- 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 >=20 |
|
From: Paul T. <pt...@wa...> - 2008-01-29 18:59:42
|
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 > > > > !DSPAM:11,479f3d5e136532958492736! > > > > > > > > ------------------------------------------------------------------------- > 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 > > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X