Re: upgrading SL 2.6.27 --> LSMB 1.1.2

[david <..hidden..>]

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 <..hidden..> 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;