Re: PostgreSQL & Raspberry Pi

Joep,

Great to hear from you and see the presentation helping people. The contrib modules, of which adminpack is one of them, are built as part of the “make world”, see page 16 of my presentation. Then all you have to do is run this sql code to install the module/extension.
CREATE EXTENSION adminpack;
You may wish to run this command in the template1 database so that it will be automatically included in any future database that you create, if you use template1 which is the default template for new databases.

There is more info about installing the contrib extenstion at the bottom of this page:
http://www.postgresql.org/docs/9.2/static/contrib.html

I run the Seattle Postgres Users Group (SeaPUG). If you have any questions about Postgres please join our mailing list and post them there. We have several dba’s who have been using Postgres for 10-12 years who will respond to questions on the list. I am one of those dba’s. You can subscribe to our mailing list at: http://www.postgresql.org/community/lists/subscribe/ just make sure to select seapug in the mailing list drop down.

Lloyd

From: jbkoyen(at)global-it-services(dot)biz [mailto:jbkoyen(at)global-it-services(dot)biz] On Behalf Of J.B.H. Koyen
Sent: Wednesday, March 13, 2013 7:13 AM
To: Albin, Lloyd P
Subject: PostgreSQL & Raspberry Pi

Dear Lloyd,

First of all, I hope that I don't intrude because I "grabbed" your email address from the Postgresql site.
Many thanks for the instructions in the "Installing Postgres on a Raspberry PI" presentation.
As a 'double' newbie for RPi & Postgresql, I really appreciated these steps.
And it works fine! (Okay, with a minor warning about IPv6 in the log, but how cares)

However when connecting with pgAdmin III I get a warning, like:

... The adminpack is installed and activated by default if you are running the one-click installer of PostgreSQL.
On Unix, you may have to install the contrib package, either with your package installer tool or by compilation..

I really like to use this Admin GUI and I tried to locate the 'contrib' package.
Unfortunately I only found suggestions like "apt-get install postgresql-contrib-9.2" :-(
Obviously that isn't available yet otherwise Ihadn't to "untar, config & make" the install.

If you could point me in the direction (or give an URL) where to search (and preferably to find), I would appreciated that (again!).
Off course I totally understand if you don't have the time to personally support every guy on the Internet.

Any way, best regards from Belgium,

Joep