Moving SQL-Ledger to Ubuntu Hardy

I struggled to find any documentation on this so here's some. This assumes everything is running on the same PC: Apache, Postgres, SQL-Ledger and you as the user.

1. Install sql-ledger
2. Go to /etc/apache2/conf.d and do

     ln -s /etc/sql-ledger/sql-ledger-httpd.conf .

   then restart apache.

3. Pointing your browser to http://localhost/sql-ledger/.

4. Now edit /etc/postgresql/8.3/main/pg_hba.conf and comment out the lines near the bottom which do the actual work and replace them with

     local all all trust

   then restart postgres¹².

5. Now you need to create yourself as a postgres user (or "role" as it's called). You do that by first becoming root and then the user postgres. Here I am doing it to create a user "paul":

     # su - postgres
  $ createuser -s paul

6. Finally while logged in as paul I can recover my database thus.

     createdb dbname
  psql dbname < backup.sql

1. I'm assuming that you've installed postgres 8.3 rather than 8.2 above.
2. Do be aware that by doing so you're allowing any user on your local PC access to the database!