Обсуждение: 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
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@gmail.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!
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"
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
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@gmail.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@gmail.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?
createdb is just a shell script for the CREATE DATABASE command that you can run from within psql.
-Mike
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