Lists: | pgsql-general |
---|
From: | "Christo Romberg" <coromberg(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Authentication & connection problems |
Date: | 2006-05-01 11:41:57 |
Message-ID: | 5f64248d0605010441h738028e0q21cdd9bd1dd7664@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
From: | "chris smith" <dmagick(at)gmail(dot)com> |
---|---|
To: | "Christo Romberg" <coromberg(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Authentication & connection problems |
Date: | 2006-05-01 12:43:29 |
Message-ID: | 3c1395330605010543u57f8ead5o35a51e7a5ce7a9e8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
> 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/
From: | "chris smith" <dmagick(at)gmail(dot)com> |
---|---|
To: | "Christo Romberg" <coromberg(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Authentication & connection problems |
Date: | 2006-05-01 14:13:04 |
Message-ID: | 3c1395330605010713we7c8e88r641d6e5a31257fde@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 5/1/06, chris smith <dmagick(at)gmail(dot)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/