On 09/07/2007 16:49, Richard Eng wrote:
> First, every time I try ‘psql’ or ‘createdb’ in the command line, it
> says the password does not match user ‘richard’. I suppose this is
> because I’m logged in to Windows as ‘richard’. ‘richard’ is my Windows
> account (administrator) under which I installed postgreSQL.
Yes, that's exactly right. You have to specify the PostgreSQL user, NOT
the Windows user, as which to execute the command, since it involves a
connection to the database. You do this with the -U switch to psql or
createdb. - Read the documentation for full details.
> Does anyone know what the hell is going on??? Hasn’t anyone used
> postgreSQL under Vista?
I you have a look through the (reasonably recent) archives of this list,
you'll see that others have and do.... you might find something of help.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------