Обсуждение: Authentication & connection problems
Hi!
I've got some problems with PostgreSQL v8.1.3 . My system is Windows XP Professional Edition.
Here's the deal. For example, when trying to connect to an existing databas, or even
creating a new one with the command createdb [dbname],
different error occurs.
Another example: when running the command psql,
entering the password and hitting enter,
the following error message occur:
psql: FATAL: password authentication failed for user "Christo"
Similarly, when testing the TCP/IP connection with the
command psql -U DATABASENAME -W -h localhost the following message shows up
psql: FATAL: database "dspace" does not exist
Do You have any ideas of what the problem could be?
Appreciate the effort!
Best Regards,
Christo
I've got some problems with PostgreSQL v8.1.3 . My system is Windows XP Professional Edition.
Here's the deal. For example, when trying to connect to an existing databas, or even
creating a new one with the command createdb [dbname],
different error occurs.
Another example: when running the command psql,
entering the password and hitting enter,
the following error message occur:
psql: FATAL: password authentication failed for user "Christo"
Similarly, when testing the TCP/IP connection with the
command psql -U DATABASENAME -W -h localhost the following message shows up
psql: FATAL: database "dspace" does not exist
Do You have any ideas of what the problem could be?
Appreciate the effort!
Best Regards,
Christo
> Here's the deal. For example, when trying to connect to an existing > databas, or even > creating a new one with the command createdb [dbname], > different error occurs. What errors exactly? We can't guess.. > Another example: when running the command psql, > entering the password and hitting enter, > the following error message occur: > > psql: FATAL: password authentication failed for user "Christo" Unless you created the user as "Christo" you should use christo - postgresql is case insensitive unless you put it in quotes. > Similarly, when testing the TCP/IP connection with the > command psql -U DATABASENAME -W -h localhost the following message shows up > psql: FATAL: database "dspace" does not exist -U is for username, not database name. Since you're not specifying a database name, it will try to use the same as the username (which you're passing in incorrectly). So that's the same as: psql -U dbname -W -h localhost dbname which is probably not what you want. -- Postgresql & php tutorials http://www.designmagick.com/
On 5/1/06, chris smith <dmagick@gmail.com> wrote: > > Here's the deal. For example, when trying to connect to an existing > > databas, or even > > creating a new one with the command createdb [dbname], > > different error occurs. > > What errors exactly? We can't guess.. > > > Another example: when running the command psql, > > entering the password and hitting enter, > > the following error message occur: > > > > psql: FATAL: password authentication failed for user "Christo" > > Unless you created the user as "Christo" you should use christo - > postgresql is case insensitive unless you put it in quotes. badly worded response there. unless you put quotes around it, postgres turns it lowercase. so Christo becomes christo ... -- Postgresql & php tutorials http://www.designmagick.com/