fix: postgres adapter settings not being applied

[ryanleecode]

Relates to:

closes: #1378

Risks

Background

What does this PR do?

What kind of change is this?

Documentation changes needed?

Testing

Where should a reviewer start?

Detailed testing steps