Search Postgresql Archives

PG utilities won't prompt for password after Win32 8.0.2 upgrade

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I accidentally posted this to win32-hackers first, instead of here
originally as I meant to.

Just when everything looked good, it went to crap again. I was able to
successfully install pltclu into one database with the command
"createlang -U postgres pltclu dbname". Upon hitting enter, I was prompted
for a password. The next time I went to run the same command, just on a
different DB, I am no longer prompted for a password, and receive the error
message, "createlang: could not connect to database template1: FATAL:
password authentication failed for user "postgres". I checked to see if this
error was specific to template1, by trying to install a different language
on the original DB. That too failed with the same error.

I have tried adding the -W, and --password options, as well as both of them
together. Whatever I do though, I cannot get createlang to prompt me for a
password.

What do I need to do to figure out this problem?

Thanks,
Steve

PS - I just tried running psql.exe and I get the same problem. I cannot get
the utilities to prompt me for a password. I used to upgrade.bat file to
upgrade, so I don't know what I could have messed up. Is there a setting, I
need to change somewhere?



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux