"Christo Romberg" <coromberg(at)gmail(dot)com> writes:
> When I try to connect to my database "dspace",
> the following error message occur:
> FATAL: database "dspace" does not exist
The error message seems perfectly clear to me ;-).
You might be getting bit by case sensitivity --- perhaps the
database is really named "DSpace" or some such? If you're
not sure, try "psql -l" to list the existing databases.
regards, tom lane