Skip to content

fix: pqutil: separate Home() and PostgresqlHome()#1295

Closed
mxmCherry wants to merge 2 commits intolib:masterfrom
mxmCherry:fix/separate-home-and-postgresql-home
Closed

fix: pqutil: separate Home() and PostgresqlHome()#1295
mxmCherry wants to merge 2 commits intolib:masterfrom
mxmCherry:fix/separate-home-and-postgresql-home

Conversation

@mxmCherry
Copy link
Copy Markdown

@mxmCherry mxmCherry commented Mar 26, 2026

Address #1294

Decided that the .../.postgresql dir is quite special (and rarely used, only for certs in this project) so decided it deserves a separate helper.

Sorry, did not bother figuring out how to run tests locally, relying on CI. Tests are passing locally. Looks like Home() helper itself is not tested at all, so did not add PostgresqlHome() tests as well.

Pls review carefully.

// Home gets the PostgreSQL configuration dir in the user's home directory:
// %APPDATA%/postgresql on Windows, and $HOME/.postgresql/postgresql.crt
// everywhere else.
// %APPDATA%/postgresql on Windows, and $HOME everywhere else.
Copy link
Copy Markdown
Author

@mxmCherry mxmCherry Mar 26, 2026

Choose a reason for hiding this comment

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

This logic is what actually matches the postgres pqGetHomeDirectory: https://github.com/postgres/postgres/blob/2b117bb/src/interfaces/libpq/fe-connect.c#L8214

  • On Unix, this actually returns the user's home directory. On Windows
  • it returns the PostgreSQL-specific application data folder.

@arp242
Copy link
Copy Markdown
Collaborator

arp242 commented Mar 30, 2026

Thanks; fixed via #1300

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants