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 -- View this message in context: http://www.nabble.com/How-Using-new-created-DB-t1334225.html#a3564598 Sent from the PostgreSQL - general forum at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
