On Tue, Oct 28, 2008 at 10:52 AM, Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> wrote:
Edit the pg_hba.conf file and add a entry for the PC you are doing your admin from and set it to Trust.
When set to trust you won't need a password, then use the admin tool of your choice to change the postgres password to whatever
you want. Afterwards remember to set it back to MD5 or whatever it was prior to you making the change.
Later,
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
My pg_hba.conf file looks like this..
-----------------------------------------------------------------------------------------------
# Database administrative login by UNIX sockets
local all postgres ident sameuser
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
host dspace dspace 127.0.0.1 255.255.255.255 md5
------------------------------------------------------------------------------------------
Can you tell me which entry should i modify or what entry should i exactly add ( as you have already mentioned)..
Please don't mind my stupid questions..I am a newbie so I don't have much idea about it..
I would greatly appreciate your help...
Thankyou..
Shashank Sahni..
