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