5x12 pentomino tiling

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 postgres12.

  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!

Tags: linux Written 26/01/09

Comment on this article

« »
I am currently reading:

A History of Women in 101 Objects by Annabelle Hirsch Game On by Janet Evanovich

Word of the Day: