Re: Documentation of .pgpass for Unix is incomplete

Thanks, Bruce! > Am 01.11.2024 um 18:32 schrieb Bruce Momjian : > > On Tue, Aug 20, 2024 at 09:24:43AM +0200, Marc Balmer wrote: >> >>> Well, it is more complicated than checking just HOME because it calls >>> getpwuid_r() if HOME is not set: >>> >>> >>> https://doxygen.postgresql.org/fe-

Re: Documentation of .pgpass for Unix is incomplete

On Tue, Aug 20, 2024 at 09:24:43AM +0200, Marc Balmer wrote: > > > Well, it is more complicated than checking just HOME because it calls > > getpwuid_r() if HOME is not set: > > > > > > https://doxygen.postgresql.org/fe-connect_8c.html#a3f49cbb20595c1765bd0db5ff434c9c3 > > > > Is it worth g

Re: Documentation of .pgpass for Unix is incomplete

stgresql.org/fe-connect_8c.html# > a3f49cbb20595c1765bd0db5ff434c9c3 > > Is it worth going into that detail in the docs? > > > > Yes, "the user's home directory" and the "HOME" environment variable are > distinct things.  The current docs are

Re: Documentation of .pgpass for Unix is incomplete

> Well, it is more complicated than checking just HOME because it calls > getpwuid_r() if HOME is not set: > > > https://doxygen.postgresql.org/fe-connect_8c.html#a3f49cbb20595c1765bd0db5ff434c9c3 > > Is it worth going into that detail in the docs? Yes definitely. This not being proper

Re: Documentation of .pgpass for Unix is incomplete

t; Description: > > > > The documentation of the .pgpass password file is incomplete in the Unix > > case (https://www.postgresql.org/docs/16/libpq-pgpass.html): > > > > It does not mention how the .pgpass File is actually found. One would > > assume it uses the getp

Re: Documentation of .pgpass for Unix is incomplete

On Thu, Aug 8, 2024 at 09:44:51AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/libpq-pgpass.html > Description: > > The documentation of the .pgpass password file is inco

Documentation of .pgpass for Unix is incomplete

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/libpq-pgpass.html Description: The documentation of the .pgpass password file is incomplete in the Unix case (https://www.postgresql.org/docs/16/libpq-pgpass.html): It does not mention

Re: More explicit documentation neede on "pgpass"

I appreciate and respect the efforts made here to help one simple user. The Microsoft reference says it is valid up to Windows Vista, so it is an excellent example of how things continue changing. I would define, as an amateur, of course, "typical" to mean "the way it is out of the box when you do

Re: More explicit documentation neede on "pgpass"

Thanks. I had missed the distinction between $APPDATA$ and %APPDATA%. I will assume that I will find that %APPDATA% defaults to ...\APPDATA\ROAMING. If one is inspired to try to "idiot-proof" the documentation, one could insert the parenthetical expression "(typically \AppData\Roaming)" for those

Re: More explicit documentation neede on "pgpass"

On Mon, Oct 03, 2022 at 09:25:58AM -0600, Geoff Michaels wrote: > Thanks. I had missed the distinction between $APPDATA$ and %APPDATA%. I > will assume that I will find that %APPDATA% defaults to > ...\APPDATA\ROAMING. > > If one is inspired to try to "idiot-proof" the documentation, one could > i

Re: More explicit documentation neede on "pgpass"

Hi, On Mon, Oct 03, 2022 at 01:50:26PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/libpq-pgpass.html > Description: > > The subdirectory of $APPDATA$ should be stated explicitly in the > doc

Re: More explicit documentation neede on "pgpass"

On Mon, 2022-10-03 at 13:50 +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/libpq-pgpass.html > Description: > > The subdirectory of $APPDATA$ should be stated explicitly in the > documentation.

More explicit documentation neede on "pgpass"

nd "\AppData\Roaming". There is no good reason to make the user guess where to create it when the address C:\Users\geoff\AppData is known and loved (but obviously not the correct answer). 34.16. The Password File The file .pgpass in a user's home directory can contain passwords to b

Re: .pgpass

Thanks Daniel ＿ 🙏 🙏 🙏 [ Have a blessed day! ] 🙏 🙏 🙏🙏 💻 My Profile 💻 Andres Leon-Rangel 📲 +64 027-498-1162 𝄗 On Thu, 10 Jan 2019 at 23:02, Daniel Gustafsson wrote: > > On 10 Jan 2019, at 04:45, PG Doc comments fo

Re: .pgpass

On Thu, Jan 10, 2019 at 11:02:08AM +0100, Daniel Gustafsson wrote: > On 10 Jan 2019, at 04:45, PG Doc comments form wrote: >> I kindly suggest to let me edit this part to create examples such as >> pg_restore -h HOST -p PORT -U SUPERUSERNAME -C -d postgres >> DBtoRESTORE.BACKUPEXTENSION >> >> th

Re: .pgpass

> On 10 Jan 2019, at 04:45, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/libpq-pgpass.html > Description: > > I kindly suggest to let me edit this part to create examples such as > pg_restore -h

.pgpass

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/libpq-pgpass.html Description: I kindly suggest to let me edit this part to create examples such as pg_restore -h HOST -p PORT -U SUPERUSERNAME -C -d postgres DBtoRESTORE.BACKUPEXTENSION

Re: Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work.

=?utf-8?q?PG_Doc_comments_form?= writes: > .pgpass does not work with 10.4 Works for me. Care to provide a complete example? $ cat $PGDATA/pg_hba.conf ... # IPv4 local connections: hostall all 127.0.0.1/32md5 # IPv6 local connections: host

Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work.

programs for PostgreSQL 10 ii postgresql-client-common190 all manager for multiple PostgreSQL client versions .pgpass does not work with 10.4 /home/ubuntu/.pgpass is 0600 (tried 0400 alsp), owner and group ubuntu with psql run as ubuntu. I tried