Re: More explicit documentation neede on "pgpass"

2022-10-04 Thread Geoff Michaels
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

Re: More explicit documentation neede on "pgpass"

2022-10-04 Thread Geoff Michaels
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"

2022-10-03 Thread Julien Rouhaud
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 >

Re: More explicit documentation neede on "pgpass"

2022-10-03 Thread Julien Rouhaud
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 >

Re: More explicit documentation neede on "pgpass"

2022-10-03 Thread Laurenz Albe
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"

2022-10-03 Thread PG Doc comments form
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 be u

Re: .pgpass

2019-02-04 Thread Andres Leon Rangel
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

Re: .pgpass

2019-01-10 Thread Michael Paquier
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 >> >>

Re: .pgpass

2019-01-10 Thread Daniel Gustafsson
> 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

.pgpass

2019-01-10 Thread PG Doc comments form
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.

2018-07-25 Thread Tom Lane
=?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.

2018-07-25 Thread PG Doc comments form
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