Skip to content
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

The psql_ssl_mode parameter does not work: when specifying a connection to the Postgresql service via a socket #8

Closed
Patebash opened this issue Jan 16, 2024 · 2 comments · Fixed by #29
Assignees
Labels
bug Something isn't working invalid This doesn't seem right

Comments

@Patebash
Copy link

Patebash commented Jan 16, 2024

Hello.

I am instructing the nxs-backup service to connect to the Postgres database via a socket with the following parameters:

connect: 
socket: /var/run/postgresql/.s.PGSQL.5432 
psql_ssl_mode: "disable" 
db_user: postgres

I get an error message when checking the configuration:

# nxs-backup
Failed initialization of jobs with the following errors:
1 error occurred:
* Failed to initialize the `server-postgresql` job. User: `postgres`, db: `, SQL connect error: pq: SSL is not enabled on the server

It seems that the psql_ssl_mode: "disable" option does not work when connected via socket

@randreev1321 randreev1321 self-assigned this Jan 18, 2024
@randreev1321 randreev1321 added bug Something isn't working invalid This doesn't seem right labels Jan 18, 2024
@randreev1321
Copy link
Collaborator

Hi @Patebash.

Thanks for your interest in nxs-backup.

Could you please specify which version of PostgreSQL you were using when you encountered this issue?

randreev1321 pushed a commit that referenced this issue Mar 15, 2024
fix(#8): Fix PSQL connection via socket
@randreev1321 randreev1321 linked a pull request Mar 15, 2024 that will close this issue
@randreev1321
Copy link
Collaborator

As part of PR #29, edits were prepared to fix a problem with connecting to PSQL via socket. A release v3.2.1 containing these fixes has been released.

Please check the updated version. If you have any new questions, we will be happy to help.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working invalid This doesn't seem right
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants