Обсуждение: 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
asAPPDATA, 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.