How do you know that the database exists?
I know it exists, because I created it when I installed PostgreSQL.
Speaking of databases: I can't even create a new database. If I run the command createdb databasename from the PostgreSQL cmd, the following error shows up:
createdb: could not connect to database postgres: FATAL: password authenticatio
n failed for user "christer"
If you load up psql, and then \c dspace, does it let you? If you \l in psql, do you see dspace?
Regarding the psql: I fail to log in to psql. When running the command after typing the password,
the following error text appear:
FATAL: password authentication failed for user "christo"
Another thing: Are you supposed to be "in" psql-mode (logged in) when running commands such as createdb?
Thanks for Your time!!!
Best Regards,
Christo
2006/5/4, Michael Artz <mlartz@xxxxxxxxx>:
How do you know that the database exists? If you load up psql, and then \c dspace, does it let you? If you \l in psql, do you see dspace?On 5/2/06, Christo Romberg <coromberg@xxxxxxxxx > wrote:Hi!
I have some problems with PostgreSQL v8.1.3.
My system is Windows XP Professional Edition.
An error occur when I try to connect to the database "dspace" that I've made.
It claims that the db does not exist, though it does.
Another error occur when try to create a new database. Then error messages says
that the password is incorrect, though it was correct given by me.
Appreciate the effort!
Best Regards,
Christo