TurnKey Linux Virtual Appliance Library

PostgreSQL AdminPack module on LAPP

MysticMan's picture
MysticMan - Sun, 2009/05/31 - 15:19

 Hello,

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.

Thanks,
MM

‹ Turnkey-Core :MKS error when loading console Power outage lost login ›
alon's picture

TurnKey appliances are essentially ubuntu underneath

Alon Swartz - Mon, 2009/06/01 - 07:49.
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

Guest - Wed, 2010/02/17 - 16:20.

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

so...

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)