Skip to content

docs: add steps for postgres server verification #12072

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 5 commits into from
Feb 25, 2024
Merged

Conversation

ericpaulsen
Copy link
Member

our current docs on connecting to PostgreSQL over SSL is only for client verification (server verifying the client). a customer gave feedback on needing the server to be verified by the client (the Coder control plane, in this case).

this PR adds steps for the PG server verification.

@ericpaulsen ericpaulsen added the docs Area: coder.com/docs label Feb 9, 2024
@ericpaulsen ericpaulsen self-assigned this Feb 9, 2024
@@ -222,7 +224,36 @@ coder:
1. Lastly, your PG connection URL will look like:

```shell
postgres://<user>:<password>@databasehost:<port>/<db-name>?sslmode=require&sslcert=$HOME/.postgresql/postgres.crt&sslkey=$HOME/.postgresql/postgres.key"
postgres://<user>:<password>@databasehost:<port>/<db-name>?sslmode=require&sslcert="$HOME/.postgresql/postgres.crt&sslkey=$HOME/.postgresql/postgres.key"
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@ericpaulsen, as this PG verification step is common to all installation methods, should it be refactored to a new section (advanced install)? It does not fit here in K8s.

Also, We should probably create a generic guide on creating a k8s secret and mounting it as a volume in the k8s pod and then refer to it within docs whenever we discuss mounting any k8s secrets.

cc: @coder/pms

Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@matifali i agree - i can move this to a guide.

@github-actions github-actions bot added the stale This issue is like stale bread. label Feb 17, 2024
@github-actions github-actions bot closed this Feb 21, 2024
@ericpaulsen ericpaulsen reopened this Feb 25, 2024
@ericpaulsen ericpaulsen enabled auto-merge (squash) February 25, 2024 01:16
@ericpaulsen ericpaulsen merged commit fb198ac into main Feb 25, 2024
@ericpaulsen ericpaulsen deleted the pg-server-auth branch February 25, 2024 01:16
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
docs Area: coder.com/docs stale This issue is like stale bread.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants