On Fri, Dec 24, 2010 at 8:29 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
> Here is the result -
> c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -d PDW -U postgres -h
> localho
> st
> psql (8.4.5)
> WARNING: Console code page (850) differs from Windows code page (1252)
> 8-bit characters might not work correctly. See psql reference
> page "Notes for Windows users" for details.
> Type "help" for help.
>
> PDW=#
Cool, so you're in. now you can use \u to see what your usernames
are. you can use alter user to change / set the password for postgres
and the other users as well now.
Then you can change pg_hba.conf back to md5 and when it asks for a
password try the one you just set.