location of pgpass.conf
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/libpq-pgpass.html
Description:
The file location needs to be more clear. It didn't work on my Local
profile, only my Roaming profile:
AppData\Roaming\postgresql
Although it should work under Local profile too as Local is more secure than
Roaming.
On Sun, May 2, 2021 at 01:38:04AM +0000, PG Doc comments form wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/libpq-pgpass.html
Description:The file location needs to be more clear. It didn't work on my Local
profile, only my Roaming profile:AppData\Roaming\postgresql
Although it should work under Local profile too as Local is more secure than
Roaming.
I don't even know what operating system you are using, let alone what a
roaming or local profile are. If you want things clarified, you have to
be clearer yourself.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
On Sat, May 01, 2021 at 11:14:43PM -0400, Bruce Momjian wrote:
On Sun, May 2, 2021 at 01:38:04AM +0000, PG Doc comments form wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/libpq-pgpass.html
Description:The file location needs to be more clear. It didn't work on my Local
profile, only my Roaming profile:AppData\Roaming\postgresql
Although it should work under Local profile too as Local is more secure than
Roaming.I don't even know what operating system you are using, let alone what a
roaming or local profile are. If you want things clarified, you have to
be clearer yourself.
AppData is a Windows thing. The documentation is correct as far as I can see,
as Windows documents the Roaming folder as APPDATA, in opposition to
LOCAL_APPDATA, which is the one OP tried first.
See https://docs.microsoft.com/en-us/windows/win32/shell/csidl for more
details.
I think you can open %APPDATA% in Windows explorer to get the correct location
if needed.
Thanks for the considering Julien/Bruce.
-----Original Message-----
From: Julien Rouhaud <rjuju123@gmail.com>
Sent: Saturday, May 1, 2021 10:27 PM
To: Bruce Momjian <bruce@momjian.us>
Cc: theman@fdrsucks.com; pgsql-docs@lists.postgresql.org
Subject: Re: location of pgpass.conf
On Sat, May 01, 2021 at 11:14:43PM -0400, Bruce Momjian wrote:
On Sun, May 2, 2021 at 01:38:04AM +0000, PG Doc comments form wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/libpq-pgpass.html
Description:The file location needs to be more clear. It didn't work on my
Local profile, only my Roaming profile:AppData\Roaming\postgresql
Although it should work under Local profile too as Local is more
secure than Roaming.I don't even know what operating system you are using, let alone what
a roaming or local profile are. If you want things clarified, you
have to be clearer yourself.
AppData is a Windows thing. The documentation is correct as far as I can see, as Windows documents the Roaming folder as APPDATA, in opposition to LOCAL_APPDATA, which is the one OP tried first.
See https://docs.microsoft.com/en-us/windows/win32/shell/csidl for more details.
I think you can open %APPDATA% in Windows explorer to get the correct location if needed.
On Sun, May 02, 2021 at 11:27:22AM +0800, Julien Rouhaud wrote:
I think you can open %APPDATA% in Windows explorer to get the correct location
if needed.
Yes, specifying an environment variable in the explorer works. This
is in line with what src/port/path.c does, so I see no actual bugs
here. If we were to change this path, I would be scared about the
amount of breakages this would create, see a3f98d5 from 2005 that
began using %APPDATA% as equivalent for $HOME.
--
Michael