Thread: postgres password
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
> 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
On Thu, 2006-06-15 at 13:24, Jasbinder Bali 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. > > Take a look here: http://www.postgresql.org/docs/8.1/static/client-authentication.html Basically, the password isn't set yet. You may or may not need to set one depending on how you configure pg_hba.conf
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
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
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.
Create a new superuser with a password, add connectivity to the pg_hba.conf file if needed and pgadmin should work fine
----- Original Message -----
----- Original Message -----
On Thu, 2006-06-15 at 13:24, Jasbinder Bali wrote: |
When you are logged in as user 'postgres' then you can run the pg_ctl reload like this:
pg_ctl -D <path of your datafolder> reload
/Shoaib
pg_ctl -D <path of your datafolder> reload
/Shoaib
On 6/16/06, LLC <kevin@kevinkempterllc.com> wrote:
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.Create a new superuser with a password, add connectivity to the pg_hba.conf file if needed and pgadmin should work fine
----- Original Message -----
> 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.
> >Take a look here:
http://www.postgresql.org/docs/8.1/static/client-authentication.html
Basically, the password isn't set yet. You may or may not need to set
one depending on how you configure pg_hba.conf
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
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:
/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:
|
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of DataIntellect
Sent: 15 June 2006 20:56
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres passwordYou cannot use the postgres account without some tweaks, Sorry I don't remember where I found this info - somewhere in the pgadmin install docs.
If it does say that anywhere, I'd love to know where so I can remove it.
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
The postgres account should be quite usable for this. You might need to edit pg_hba.conf as well of course.
Regards,. Dave