On Thu, 2006-03-23 at 20:18, LJJGIS wrote:
> Connect to postgres with
>
> c:\>psql.exe -h localhost -p 5432 postgres "postgres"
>
> And then
> postgres=# create database mydb
>
> Then I try to connect to "mydb" with
>
> C:\> psql mydb
> After try many password, include postgres password and OS user password
> report ** psql: FATAL: password authentication failed for user
> "Administrator" **
> OR
> C:\>psql -h localhost -p 5432 mydb "mydb"
> After try many password, include postgres password and OS user password
> report ** psql: FATAL: password authentication failed for user "mydb" **
>
> Could someone here help to illustrate how to connect to a newly created
> database
Is this on the same machines(s)? I.e. are you running psql on the same
machine (client) against he same machine (server) for both examples?
Also, note that in the first example, you're connecting via tcp/ip with
-h localhost -p 5432, but in the second example you're not specifying
those things. Have you tried changing ONLY the database name and
specifying the username postgres?
PostgreSQL has an internal set of names it uses. They don't come from
the OS. You need to use the "create user" and "alter user" commands to
create and change those.
It's all in the docs at:
http://www.postgresql.org/docs/8.1/static/sql-createuser.html
