Re: upgrading SL 2.6.27 --> SMB 1.12

["Chris Travers" <..hidden..>]

On Wed, Sep 10, 2008 at 7:26 AM, david <..hidden..> wrote:
> I've got to the point that I can log in to admin.pl successfully, and
> I've created a database on the new installation. I have  both packages
> (SL/SMB) running on the same host (Postgresql 8.3 btw). Databases are:
>
> SL:     2008
> SMB:    2009
>
> Curiosity:
> I can see both databases from either admin page. How can that be?

The admin page shows all databases in the PostgreSQL cluster.

> They
> have different postgresql users. I can't log in from the login.pl page.
>
> Question:
> My next step is to migrate the data, and I really want to get this part
> right.
> I've backed up SL using System/Backup/SaveToFile.
> Are the following steps correct:
>
> ..hidden..:~# su - postgres
> ..hidden..:~$ psql -h localhost -U  ledger-smb -d 2009
> <password>
> postgres=# \i  </path/to/BackupOf2008unzipped>
> postgres=# \q
> ..hidden..:~$ exit
> ..hidden..:~# /usr/local/ledger-smb/SL2LS.pl
> Then log in to admin.pl with a browser, etc, etc.....


You also need to run the following sql scripts in sql/legacy (in order):

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

That should be all that is required.

Best Wishes,
Chris Travers