TurnKey Linux Virtual Appliance Library

PostgreSQL AdminPack module on LAPP

MysticMan's picture


Can anyone post any tips or pointers for getting the PostgreSQL AdminPack module up any running on my LAPP appliance?

Any help would be greatly appreciated.


Alon Swartz's picture

TurnKey appliances are essentially ubuntu underneath

TurnKey appliances are essentially ubuntu underneath, so you can follow the ubuntu/debian tutorials and you should be fine.

A quick search showed that the adminpack is part of the postgresql-contrib package, so something like the following should work:
apt-get update
apt-get install postgresql-contrib
psql -U postgres -d postgres < /usr/share/postgresql/8.3/contrib/adminpack.sql
I haven't tried the above, but it should work.

Good luck!
Guest's picture

at least trying with version

at least trying with version 8.4 the database has to be "template1"


psql -U postgres -d template1 < /usr/share/postgresql/8.4/contrib/adminpack.sql

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)