Message-ID: <gh-pgjdbc-pgjdbc-3700@github.com>
From: "harinath001 (@harinath001)" <noreply+harinath001@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 30 Jun 2025 20:04:07 +0000
Subject: [pgjdbc/pgjdbc] PR #3700: Add PEMKeyManager to handle PEM based certs and keys.
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Id: 9057411
X-GitHub-Author-Login: harinath001
X-GitHub-Issue: 3700
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: merged
X-GitHub-Type: pull_request
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/pull/3700
Content-Type: text/plain; charset=utf-8

### Context

I found that PGJDBC currently lacks support for PEM based certs and keys.

We have a use case where PEM files are auto renewed on disk and
converting them to DER format requires running something that watches
files on disk and auto-converts to DER.

Hence I would like to propose a patch for supporting PEM based certs, keys.

### New Feature Submissions:

1. [x] Does your submission pass tests?
2. [x] Does `./gradlew styleCheck` pass ?
3. [x] Have you added your new test classes to an existing test suite in alphabetical order?

### Changes to Existing Features:

- Adding support for PEM based certs will not affect the existing behavior.
- Added new tests for PEMKeyManager