2

Is there a way to install the optional adminpack (contrib) tools for utilizing pgAdmin on an Amazon RDS PostgreSQL instance? My gut says no because of this question. When you don't have the tools installed you get the following message every time you connect via pgAdmin.

Server instrumentation not installed

I understand the tools aren't required but if available I'd like to install them (if for no other reason than to remove the warning). When I connect to a DB instance on a Ubuntu server I can just apt-get them or click the Fix It button when connecting via pgAdmin, but I'm not sure how to (or if I can even) accomplish this on an RDS instance.

Community
  • 1
Joel B
  • 123
  • 5

1 Answers1

4

You will not be able to install any additional software on an Amazon RDS instance, because RDS is offered as a "software-as-a-service" (SaaS) platform.

With most/all SaaS offerings, you only get access to an endpoint and a limited set of configuration variables, and are not given access to the underlying architecture (e.g. OS, networking, hardware).

If you require anything other than the interface that Amazon provide, you will need to run your own PostgreSQL installation on top of an Amazon EC2 instance.

Craig Watson
  • 9,575
  • 3
  • 32
  • 47
  • I figured this was the answer, i just wasn't sure if i missed some checkbox along the way when setting up the DB. – Joel B Aug 24 '15 at 13:30
  • @JoelB no problem, if the question has been answered to your satisfaction, please do mark the answer as accepted :) – Craig Watson Aug 24 '15 at 17:59
  • I def will, I just want to give it day to see if someone doesn't come by with some clever hack. Also, SE gets feisty if you accept an answer within an hour of asking. – Joel B Aug 24 '15 at 22:05