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

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

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
>

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
> >
>
>

I highly suggest reading the manuals, specifically the first link to the
windows installation instructions:
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html
http://www.postgresql.org/docs/8.1/interactive/index.html

You are getting an error because either you entered in the wrong password or
the database user 'christo' doesn't exist.

Do you have a "psql to 'postgres'" link in your start menu? When you click
on that and enter the password you set up upon install, what happens?

Another thing: Are you supposed to be "in" psql-mode (logged in) when
> running commands such as createdb?
>

createdb is just a shell script for the CREATE DATABASE command that you can
run from within psql.

-Mike