Re: PG on AWS RDS and IAM authentication

From: Steven Lembark <lembark(at)wrkhors(dot)com>
To: Ravi Krishna <sravikrishna3(at)gmail(dot)com>
Cc: PG mailing List <pgsql-general(at)lists(dot)postgresql(dot)org>, lembark(at)wrkhors(dot)com
Subject: Re: PG on AWS RDS and IAM authentication
Date: 2018-06-14 13:41:21
Message-ID: 20180614084121.416d7c20@wrkhors.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 12 Jun 2018 11:45:01 -0400
Ravi Krishna <sravikrishna3(at)gmail(dot)com> wrote:

> https://forums.aws.amazon.com/thread.jspa?threadID=258822&tstart=0
> there was no IAM authentication for PG on AWS RDS. (It is there for
> MySQL). However the link is a year old. Has it changed since then?
> Can we use IAM authentication for PG.

Nothing to do with PG specifically, but you can use IAM to manage
access to the server by host or VPC. The simplest way is to create
a role and assign it to the hosts that are going to access the
server.

You can also create some accounts that are granted access to the
RDS instances.

If you need more help with this feel free to contact me outside
of the list.

--
Steven Lembark 1505 National Ave
Workhorse Computing Rockford, IL 61103
lembark(at)wrkhors(dot)com +1 888 359 3508

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Moreno Andreo 2018-06-14 13:56:12 catalog is missing n attribute(s) for relid xxxx at character yy
Previous Message Adrian Klaver 2018-06-14 13:37:04 Re: How to reference a composite type in schemas not "public"?