![]() Upon installation, I had created a superuser "postgres" with password "a", not a user "A" on the other hand, I am user "A" which is my Windows admin (!) account (no other users than myself on my pc) and the cmd prompt I usually get ("C:\Users\A>") (but as expected,) no different result if I enter the whole path to psql.exe from the prompt "C:>". On the other hand, with the first strategy above, I only get "Password:" and then, after entry of the real password (which is "a"), the "FATAL" error "password authentication failed for user "A"". Password for user postgres: I enter the password which is "a".įrom there, I get a warning re the Console code page which differs from Windows code page, but I then get the psql prompt postgres=# Within the Start menu, there is an entry "PostgreSQL" under that - available by Enter - there is a sub-entry "SQL Shell (psql)" so I tried that.įrom there only, I get the Windows cmd window, with "psql 10.1" and with (in it's obviously the default values): Server : I enter localhost I find a help file libpq-pgpass.html which also says that, while on my system, there is no such file nf (or anything else with "pgpass" except for the aforementioned html file). It's said in other threads here re this question that in Windows, there is a file nf. Other threads in this forum regarding pg password fails concern Linux / outdated passwords / new passwords after password changes. This corresponds to the problem described (but not resolved) in the Q/A cited above. ![]() Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?įATAL: password authentication failed for user "User" Psql: could not connect to server: Permission denied (0x0000271D/10013) In the generic (Windows) command window, I now got the message: In line with Q/A In PostgreSQL why does command line window disappear when I press Enter after entering my password?, now, instead of running psql.exe directly, I first opened a generic (Windows) command window and then ran psql.exe from within this generic command window I then entered the password and hit Enter. I tried both, with identical (negative) results. In my system, I find psql.exe not once, but twice, why? ( C:\Program Files (x86)\pgAdmin 4\v2\runtime\psql.exe and C:\Program Files\PostgreSQL\10\bin\psql.exe). I understand that in order to interact with pg, I must use psql.exe.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |