Sorry.. it's me again.... I must be brain dead, so please forgive me. When I run Pg-upgrade-2.6.18-2.6.19.sql I get a stack of errors and not much else.
Remembering that I'm keeping the old SL system live and installing a parallel LSMB I'm assuming the order is as follows: 1. Original Database in SL is 2008 to be kept pristine 2. Clone 2008 in SL and call it 2009SL 3. Log into 2009SL in sql-ledger/admin.pl 4. Log out of sql-ledger/admin.pl 5. run Pg-upgrade-2.6.12-2.6.17.sql in SL 6. Log in and out? Is this necessary? 7 run Pg-upgrade-2.6.17-2.6.18.sql in SL 8 Log in and out? 9 run Pg-upgrade-2.6.18-2.6.19.sql in SL? or is this for lsmb 1.2.x? 10 Log in... create a back up. Or use pg_dump perhaps? 11 create a new lsmb installation with a database called 2009LSMB 12 import the back up from SL in step 10 13 run SL2LS.pl 14 log in to lsmb, admin.pl, etc Pg-upgrade-2.6.18-2.6.19.sql was not included in the LSMB 1.1.2 tarball, so I'm kinda thinking it isn't needed there. Is that the right place and sequence to run those Pg-upgrade scripts? Have I missed documentation somewhere? I haven't been able to find anything that either * tells me to run those Pg-upgrade scripts, or * where in the process to do them, or even in which system * I'm assuming they are SL scripts... are they? thanks... David. david wrote: > david wrote: >> Chris Travers wrote: >>> On Wed, Sep 10, 2008 at 7:04 PM, david <[EMAIL PROTECTED]> wrote: >>> >>> >>>>> Pg-upgrade-2.6.12-2.6.17.sql >>>>> Pg-upgrade-2.6.17-2.6.18.sql >>>>> Pg-upgrade-2.6.18-2.6.19.sql >>>>> >>>> Thanks... but..... ;-) >>>> >>>> I'm already in SL 2.6.27... doesn't that mean these are not required? >>>> (see subject line) >>>> >>>> thanks for you excellent work and help. >>> If you: >>> >> select dbversion from defaults; [1] >> >>> you will get 2.6.12, hence the scripts to run. >>> >> hmm... that is SO counter-intuitive! So the database version is 2.6.12 >> and I have to upgrade to 2.6.19 even though I'm running SL 2.6.27 >> Is that documented? >> >> At the risk of appearing ungrateful, shouldn't that instruction to run >> the Pg_upgrade files be included in README.sql-ledger? >> >> Next problem is that Pg-upgrade-2.6.18-2.6.19.sql file does not exist. >> > > > I found it in the LSMB 1.2 tarball. does this mean it only applies to > 1.2.x ? > > Sorry for the endless questions, but I don't want to end up with a > corrupted database. > > > >> I'm using LSMB 1.1.2 btw ... not 1.12 as originally in my subject line. >> >> many thanks.... >> >> david >> >> [1] select version from defaults; >> > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
