Re: FATAL: database "dspace" does not exist"

Hi!

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(at)gmail(dot)com>:
>
> 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(at)gmail(dot)com > 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
> >
>
>