I've got some problems with PostgreSQL v8.1.3 . My system is Windows XP Professional Edition.
Here's the deal. For example, when trying to connect to an existing databas, or even creating a new one with the command createdb [dbname], different error occurs.
Another example: when running the command psql, entering the password and hitting enter, the following error message occur:
psql: FATAL: password authentication failed for user "Christo"
Similarly, when testing the TCP/IP connection with the command psql -U DATABASENAME -W -h localhost the following message shows up
psql: FATAL: database "dspace" does not exist
Do You have any ideas of what the problem could be?