Skip site navigation (1) Skip section navigation (2)

Re: PSQL under Windows XP

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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'.


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

What am I missing here? 


Do you Yahoo!? 
Yahoo! Small Business - Try our new Resources site

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


pgsql-novice by date

Next:From: Kevin CrenshawDate: 2005-05-30 13:53:37
Subject: Re: Unable to Delete a Row
Previous:From: Danny GaethofsDate: 2005-05-30 09:50:53
Subject: PSQL under Windows XP

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group