Richard Eng wrote:
> I’m new to postgreSQL. I’m running Windows Vista Home Premium. I tried
> installing it (I had to turn off UAC), enabling user ‘postgres’ for
> running it as a Service. But I’m encountering some really bizarre
> problems...
>
> 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.
createdb or psql --help is your friend. It might be -h on windows. You
can pass the postgres user like this:
psql -U postgres
or
createdb -U postgres
The fine manual explains all of this.
http://www.postgresql.org/docs/8.2/static/index.html
Sincerely,
Joshua D. Drake
>
> BUT, I cannot login as ‘postgres’ because even though the installation
> created this user, it is not visible in the User Accounts of Control
> Panel! If I log off from ‘richard’, there is no way to login as ‘postgres’.
>
> AND, I know the ‘postgres’ account is there somewhere because if I try
> to create it, it says the account already exists! So it exists but it’s
> not visible?! PostgreSQL installation has REALLY, REALLY screwed things up!
>
> Does anyone know what the hell is going on??? Hasn’t anyone used
> postgreSQL under Vista?
>
> Thanks,
> Richard
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/