On Sun, Mar 13, 2011 at 11:40 PM, Fredy Khan <[email protected]> wrote:
> Hello i have postgresql 9.0 and i am using windows xp. In command prompt i > go to my installation bin c:\postgresql\9.0\bin n run pgsql.exe. The problem > is that after that it asks for a password for my window account which is > 'fredy' . I have not set any password n if i enter my user account password > it dosnt work. i have also tried admin, postgres, etc but nothing works. I > would appreciate elp in this matter. thank u > Could you please try below steps to connect the PostgreSQL Database:: 1. Please issue the following command in the run box ( start --> run ) as follows: runas /user:postgres cmd This command opens command prompt as a postgres user. 2. Now connect the database using below command: cd c:\postgresql\9.0\bin psql.exe -d postgres -p 5432 -U postgres Password:: [Provide postgres user assigned password at the time of installation] --Raghu Ram
