dbTalk Databases Forums  

[BUGS] BUG #2363: password authentication failed

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2363: password authentication failed in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
zhu
 
Posts: n/a

Default [BUGS] BUG #2363: password authentication failed - 03-29-2006 , 10:13 AM







The following bug has been logged online:

Bug reference: 2363
Logged by: zhu
Email address: vispper (AT) 163 (DOT) com
PostgreSQL version: 8.1.3
Operating system: winxp sp2
Description: password authentication failed
Details:

i download a non-install version of psql, and install it in volumn f:, but i
can not use psql.exe on f:, other volumn was ok. why???

----------------- system information
c: fat16
d: fat32
e: ntfs (system volumn)
f: ntfs (psql app/data volumn)

----------------- how do i run the app
download a non-install 8.1.3 of psql zip file.
extract into f:\soft
goto psql\bin, run
"initdb -D ../data -A md5 -W"
after input superuser's password, i start it
"pg_ctl -D ../data start

----------------- psql commands
C:\>F:\soft\psql8\bin\psql.exe
口令: ^C
C:\>d:
D:\>F:\soft\psql8\bin\psql.exe
口令: ^C
D:\>e:
E:\>F:\soft\psql8\bin\psql.exe
口令: ^C
E:\>f:
F:\>F:\soft\psql8\bin\psql.exe
psql: FATAL: password authentication failed for user "zhu"

----------- pg_ctl LOG
F:\soft\pgsql8\bin>LOG: database system was shut down at 2006-03-29
18:11:24 Ch
ina Standard Time
LOG: checkpoint record is at 0/38C2C0
LOG: redo record is at 0/38C2C0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 567; next OID: 10794
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484148, limited by database
"postgres"
FATAL: password authentication failed for user "zhu"

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote
  #2  
Old   
Magnus Hagander
 
Posts: n/a

Default Re: [BUGS] BUG #2363: password authentication failed - 03-29-2006 , 12:54 PM






Quote:
The following bug has been logged online:
=20
Bug reference: 2363
Logged by: zhu
Email address: vispper (AT) 163 (DOT) com
PostgreSQL version: 8.1.3
Operating system: winxp sp2
Description: password authentication failed
Details:=20
=20
i download a non-install version of psql, and install it in=20
volumn f:, but i can not use psql.exe on f:, other volumn was=20
ok. why???
=20
This lokos like a known issue that will be fixed in 8.1.4. Check if you
have a directory called "dev" in the root of the drive that's current
when you run psql (to be sure, check all drives). If it's there, rename
or remove it.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.