Re: I "might" have found a bug on 8.2.1 win32

Well, there is something weird going on here:

If I change the postgres users password to the one I used during install
I get this when using psql:

C:\Program Files\PostgreSQL\8.2\bin>psql template1 -U postgres
DEBUG: InitPostgres
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid
1348/1/0, nestlvl: 1, children: <>
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid
1348/1/0, nestlvl: 1, children: <>
Welcome to psql 8.2.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters may not work correctly. See psql reference
page "Notes for Windows users" for details.

template1=#

If I change the password to anything else I get this:

C:\Program Files\PostgreSQL\8.2\bin>psql template1 -U postgres
psql: FATAL: password authentication failed for user "postgres"

I did a search for a password file but it came back empty.

Anyone have any ideas on why this is happening?

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration