[Pkg-sql-ledger-discussion] Bug#675816: ledgersmb: Unable to upgrade from 1.2 db to 1.3 db

[Robert James Clay]

On Sun, 2012-06-03 at 14:47 -0400, Moshe Yudkowsky wrote:
> Robert James Clay wrote, On 06/03/2012 01:22 PM:
> >     Can you successfully create a new test database and access that?
> > (IIRC, that also uses the Pg extensions...)
> 
> Sorry, I should have mentioned that: Yes, I did create one as a test and 
> I can access it.

    None of those other http related errors while logged in that way?


>  I should mention that access to the db seems a bit 
> tricky -- AFAICT I need to create a user in the db that also is a user 
> of the db as a whole 

    What I do for the setup.pl login is manually create a separate
'ledgersmb' database superuser (instead of using 'postgres') using the
following SQL:

CREATE ROLE ledgersmb WITH SUPERUSER LOGIN NOINHERIT ENCRYPTED PASSWORD
'password';

   Then use that for any of the Database Management Console (setup.pl)
log ins.    




Jame