Im trying to restore a backed up database and am following the FAQ. When i go to double click on the "PostgreSQL Database Server 8.2" in PG admin it asks for my password. Is this password the user account password? I must be getting it wrong because Ive tried all passwords I wrote down but keep getting a "Error connecting to the server:FATAL role "slamdunka" does not exist" error.
During install I had some problems with vista and during the uninstalling/reinstalling it looks like I made a couple of user accounts for postgre. I really didnt get the user account name/pass vs the database name/pass. I think I do now.
I guess my question is can I change user accounts for postgre or can I recover/change the password for the user account. Or is this even my problem at all?