From: | "Kevin Crenshaw" <kcrenshaw(at)tiewireinc(dot)com> |
---|---|
To: | "Danny Gaethofs" <dgaethofs(at)yahoo(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: PSQL under Windows XP |
Date: | 2005-05-30 13:52:30 |
Message-ID: | D8439C286CD66D4EBD89F853EBCE6E210F7BA3@ccs1.tiewireinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Danny,
What works for me is to log in as 'postgres' on the template1 database.
>From there you can use the 'create database' command to create a new
database. When that's done, quit template1 and then log in to the new
database as 'postgres'.
HTH,
kevin crenshaw
-----Original Message-----
From: Danny Gaethofs [mailto:dgaethofs(at)yahoo(dot)com]
Sent: Monday, May 30, 2005 5:51 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] PSQL under Windows XP
dear all,
I have a question about creating a database.
I can create a database easily using pgAdminiii, but I
am trying to get it done using psql.
When I try to start the psql editor using psql
I get the message psql: FATAL: Password authentication
failed for user ....
I think I need to login as the administrator. I looked
at the psql to template1 command which is working. I
found the following command:
psql.exe -h localhost -p 5432 template1 "postgres"
Now I would like to use it but not with template1.
How can I login the psql interactive terminal as the
administrator. It works with the above command for
template1.
What am I missing here?
regards,
Danny
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Crenshaw | 2005-05-30 13:53:37 | Re: Unable to Delete a Row |
Previous Message | Danny Gaethofs | 2005-05-30 09:50:53 | PSQL under Windows XP |