pg.ddx.io GitHub: postgresql-interfaces/psqlodbc (issues + PRs as email threads)
help / color / mirror / Atom feed[postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
7+ messages / 2 participants
[nested] [flat]
* [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
@ 2026-09-24 22:58 "praba2210 (@praba2210)" <noreply+praba2210@github.com>
0 siblings, 0 replies; 7+ messages in thread
From: praba2210 (@praba2210) @ 2026-09-24 22:58 UTC (permalink / raw)
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
### Summary
Hi, I’m a developer on the Amazon Aurora DSQL team. Aurora DSQL uses the PostgreSQL wire protocol with IAM authentication and TLS. psqlODBC users currently require external code or proxies to generate and manage IAM tokens, adding operational complexity.
### Proposed Support
Add an optional Aurora DSQL connection mode that:
- Uses the AWS credential chain.
- Resolves the AWS Region from the DSQL endpoint.
- Generates the appropriate IAM token for each new connection.
- Supports standard and admin database roles.
- Handles full-length tokens securely without persisting them.
- Enforces TLS certificate and hostname validation.
- Applies DSQL-compatible connection and session behavior.
The implementation would be isolated so existing PostgreSQL behavior remains unchanged. It may require an optional AWS authentication dependency, and I’m open to guidance on the preferred integration approach.
If this proposal is acceptable, I can prepare and submit a PR for upstream review. Looking forward to your feedback. Thanks!
^ permalink raw [nested|flat] 7+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
@ 2026-09-24 23:05 "praba2210 (@praba2210)" <noreply+praba2210@github.com>
5 siblings, 0 replies; 7+ messages in thread
From: praba2210 (@praba2210) @ 2026-09-24 23:05 UTC (permalink / raw)
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
@praba2210 renamed this.
^ permalink raw [nested|flat] 7+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
@ 2026-09-29 00:00 "davecramer (@davecramer)" <noreply+davecramer@github.com>
5 siblings, 0 replies; 7+ messages in thread
From: davecramer (@davecramer) @ 2026-09-29 00:00 UTC (permalink / raw)
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
Have you seen https://github.com/aws/aws-advanced-odbc-wrapper
^ permalink raw [nested|flat] 7+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
@ 2026-09-29 16:50 "praba2210 (@praba2210)" <noreply+praba2210@github.com>
5 siblings, 0 replies; 7+ messages in thread
From: praba2210 (@praba2210) @ 2026-09-29 16:50 UTC (permalink / raw)
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
> Have you seen https://github.com/aws/aws-advanced-odbc-wrapper
Thanks for the link, I'll check it out!
^ permalink raw [nested|flat] 7+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
@ 2026-10-13 19:09 "praba2210 (@praba2210)" <noreply+praba2210@github.com>
5 siblings, 0 replies; 7+ messages in thread
From: praba2210 (@praba2210) @ 2026-10-13 19:09 UTC (permalink / raw)
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
Hi @davecramer , I looked at the wrapper. Its IAM plugin generates RDS IAM tokens, which Aurora DSQL
doesn't accept because DSQL tokens are signed for a different service (`dsql`, with
`DbConnect`/`DbConnectAdmin`). So today psqlODBC users have to generate the DSQL IAM token outside
the driver and pass it as the password. Those tokens expire, so every new connection needs a fresh
one, and native support would let psqlODBC generate one per connection instead of relying on
external scripts or proxies.
Please let me know what do you think of DSQL upstream? Thanks.
^ permalink raw [nested|flat] 7+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
@ 2026-10-13 19:52 "davecramer (@davecramer)" <noreply+davecramer@github.com>
5 siblings, 0 replies; 7+ messages in thread
From: davecramer (@davecramer) @ 2026-10-13 19:52 UTC (permalink / raw)
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
@praba2210 how much trouble would it be to change the wrapper version to use DSQL tokens ?
^ permalink raw [nested|flat] 7+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
@ 2026-10-13 21:07 "praba2210 (@praba2210)" <noreply+praba2210@github.com>
5 siblings, 0 replies; 7+ messages in thread
From: praba2210 (@praba2210) @ 2026-10-13 21:07 UTC (permalink / raw)
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
@davecramer Not much trouble. The wrapper's auth flow is generic, only the token generation is RDS specific, so adding DSQL specific feature is straightforward.
For long term, I'd still like to have native DSQL IAM auth in psqlODBC as an optional, so user don't need second driver?
^ permalink raw [nested|flat] 7+ messages in thread
end of thread, other threads:[~2026-10-13 21:07 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-09-24 22:58 [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support "praba2210 (@praba2210)" <noreply+praba2210@github.com>
2026-09-24 23:05 ` "praba2210 (@praba2210)" <noreply+praba2210@github.com>
2026-09-29 00:00 ` "davecramer (@davecramer)" <noreply+davecramer@github.com>
2026-09-29 16:50 ` "praba2210 (@praba2210)" <noreply+praba2210@github.com>
2026-10-13 19:09 ` "praba2210 (@praba2210)" <noreply+praba2210@github.com>
2026-10-13 19:52 ` "davecramer (@davecramer)" <noreply+davecramer@github.com>
2026-10-13 21:07 ` "praba2210 (@praba2210)" <noreply+praba2210@github.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox