You cannot use the postgres account without some tweaks, Sorry I don't remember where I found this info - somewhere in the pgadmin install docs.
However this works:
Create a new superuser with a password, add connectivity to the pg_hba.conf file if needed and pgadmin should work fine
/Kevin
----- Original Message -----
| Change the following in pg_hba.conf host all all 127.0.0.1/32 md5 to host all all 127.0.0.1/32 trust and that will let you connect without password and then reload your db server settings using 'pg_ctl reload'. You can then set the password once connected to database using alter user username password 'password' Once you are done with that now you can switch back to original authentication mode. /Shoaib On 6/15/06, Jasbinder Bali < jsbali@gmail.com> wrote: Hello,
> I'm trying to connect to the local postgres database using pgadmin. It
> asks for a password that i never set and hence i'm not able to connect
> to my local postgres database.
> Also, when i click postgresql help option in the Help tab of pgadmin,
> the pgadmin screen would close down. Don't know whats going on wrong.
>
> Thanks,
> ~Jas
|