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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to