pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedlocation of pgpass.conf
5+ messages / 5 participants
[nested] [flat]
* location of pgpass.conf
@ 2021-05-02 01:38 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: PG Doc comments form @ 2021-05-02 01:38 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: theman@fdrsucks.com
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: location of pgpass.conf
@ 2021-05-02 03:14 Bruce Momjian <bruce@momjian.us>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2021-05-02 03:14 UTC (permalink / raw)
To: theman@fdrsucks.com; pgsql-docs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: location of pgpass.conf
@ 2021-05-02 03:27 Julien Rouhaud <rjuju123@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 2 replies; 5+ messages in thread
From: Julien Rouhaud @ 2021-05-02 03:27 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: theman@fdrsucks.com; pgsql-docs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: location of pgpass.conf
@ 2021-05-02 03:46 William F. Robertson, Jr <me@billrob.com>
parent: Julien Rouhaud <rjuju123@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: William F. Robertson, Jr @ 2021-05-02 03:46 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; Bruce Momjian <bruce@momjian.us>; +Cc: theman@fdrsucks.com <theman@fdrsucks.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: location of pgpass.conf
@ 2021-05-08 09:01 Michael Paquier <michael@paquier.xyz>
parent: Julien Rouhaud <rjuju123@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Michael Paquier @ 2021-05-08 09:01 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: Bruce Momjian <bruce@momjian.us>; theman@fdrsucks.com; pgsql-docs@lists.postgresql.org
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
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-05-08 09:01 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-05-02 01:38 location of pgpass.conf PG Doc comments form <noreply@postgresql.org>
2021-05-02 03:14 ` Bruce Momjian <bruce@momjian.us>
2021-05-02 03:27 ` Julien Rouhaud <rjuju123@gmail.com>
2021-05-02 03:46 ` William F. Robertson, Jr <me@billrob.com>
2021-05-08 09:01 ` Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox