On Wed, Sep 10, 2008 at 7:26 AM, david <[EMAIL PROTECTED]> 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: > > [EMAIL PROTECTED]:~# su - postgres > [EMAIL PROTECTED]:~$ psql -h localhost -U ledger-smb -d 2009 > <password> > postgres=# \i </path/to/BackupOf2008unzipped> > postgres=# \q > [EMAIL PROTECTED]:~$ exit > [EMAIL PROTECTED]:~# /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 ------------------------------------------------------------------------- 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
