Re: 8.0 installs ok, but then...
От | Jon Allen |
---|---|
Тема | Re: 8.0 installs ok, but then... |
Дата | |
Msg-id | BBB646166E3FCE46A5E9CE14B252558602D5ECD5@MERC27.na.sas.com обсуждение исходный текст |
Ответ на | 8.0 installs ok, but then... ("Jon Allen" <Jon.Allen@sas.com>) |
Ответы |
Re: 8.0 installs ok, but then...
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-novice |
Thanks for the response. First, more background: - running on win xp - my pc is the only one with this problem in a group of about 20 upgrades - made sure there's nothing in my PATH that would cause this problem - found a workaround: changed "md5" to "trust" in pg_hba.conf > ...every psql command I issue gets this response: > psql: FATAL: password authentication failed for user "postgres" even > though there is no password prompt. What shows up in the postmaster log? I can't find a postmaster log. Didn't know what one was til your question prompted me to find out, and I'm having troublemapping the doc's unix examples to my win environment. As far as I can figure, the postmaster task on my pc is thePostgreSQL Database Server 8.0 service. And I haven't figured out yet where the log is for that. Here's the content of C:\Program Files\PostgreSQL\8.0\data\pg_log\postgresql-2005-03-23_000000.log: 2005-03-23 11:03:29 FATAL: password authentication failed for user "jon.allen" 2005-03-23 11:05:08 FATAL: password authentication failed for user "postgres" 2005-03-23 11:24:05 FATAL: password authentication failed for user "postgres" 2005-03-23 13:36:41 FATAL: password authentication failed for user "jon.allen" 2005-03-23 13:36:48 FATAL: password authentication failed for user "jon.allen" 2005-03-23 13:36:52 FATAL: password authentication failed for user "jon.allen" 2005-03-23 13:36:54 FATAL: password authentication failed for user "jon.allen" 2005-03-23 15:07:02 LOG: received fast shutdown request 2005-03-23 15:07:02 LOG: shutting down 2005-03-23 15:07:02 LOG: database system is shut down 2005-03-23 15:07:03 LOG: logger shutting down > I don't have any .pgpass files on my system. How about PGPASSWORD environment variable? No postgres-related environment variables. > The install log mentions errors 1707 and 1709, but I can't find any > reference to them. Actually showing them to us might help... The last 12 lines from the install log (let me know if you need to see the whole 3 Mb): === Logging stopped: 3/22/2005 15:47:39 === MSI (c) (14:60): Note: 1: 1707 MSI (c) (14:60): Note: 1: 2205 2: 3: Error MSI (c) (14:60): Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1707 MSI (c) (14:60): Note: 1: 2205 2: 3: Error MSI (c) (14:60): Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 MSI (c) (14:60): Product: PostgreSQL 8.0 -- Installation completed successfully. MSI (c) (14:60): Grabbed execution mutex. MSI (c) (14:60): Cleaning up uninstalled install packages, if any exist MSI (c) (14:60): MainEngineThread is returning 0 === Verbose logging stopped: 3/22/2005 15:47:40 ===
В списке pgsql-novice по дате отправления: