2개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
I was able to figure it out! We're using the aws python lambda docker image. I had to compile the pg tools from source. The pg tools installable from yum on this container will only install major version 9 of the tools which is not compatible with the scram style of password encryption.
RUN yum install -y wget gcc tar make libpqxx-devel gzip && \ yum install -y https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-7-x86_64/postgresql14-libs-14.5-1PGDG.rhel7.x86_64.rpm && \ wget https://ftp.postgresql.org/pub/source/v14.5/postgresql-14.5.tar.gz && \ tar -xf postgresql-14.5.tar.gz && \ cd postgresql-14.5 && \ ./configure --with-python --without-readline --without-zlib && \ make && \ make install && \ export PATH="/usr/local/pgsql/bin:$PATH" && \ python3 -m pip install --upgrade pip setuptools wheel boto3 pygresql
답변함 일 년 전
0
Hi,
may not answer directly your question, but have you considered ditching the lambda in favour of the native rds-secret manager integration released a few months ago?
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-secrets-manager.html
Let me know, regards
This is a cool new feature I didn't know about!
However it doesn't exactly fit our use-case. This will rotate the "master" user password but we have other users (ones we define) that we need to rotate. Thank you for the help though alatech!