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

[Moshe Yudkowsky]

Robert James Clay wrote, On 06/03/2012 02:54 PM:
> 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.

Thanks, I hit on the same solution, and it works quite well.

-- 
Moshe Yudkowsky * moshe at pobox.com * www.pobox.com/~moshe
"The Constitution is ... quite succient -- 21 pages giving complete 
operating
instructions for a nation of 250 million people. The manual for a Toyota
Camry,  which only seats five, is four times as long." -- P. J. O'Rourke