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

From: "Steve - DND" <postgres(at)digitalnothing(dot)com>
To: "postgres-general" <pgsql-general(at)postgresql(dot)org>
Subject: PG utilities won't prompt for password after Win32 8.0.2 upgrade
Date: 2005-04-19 00:55:56
Message-ID: LDEHKBBOEMIJKHKBOFNFCEKMNEAA.postgres@digitalnothing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2005-04-19 01:17:14 Re: Plpgsql function with unknown number of args
Previous Message Kris Jurka 2005-04-19 00:33:00 Re: current transaction is aborted, commands ignored until