On Tue, Oct 28, 2008 at 10:52 AM, Tony Caduto < [EMAIL PROTECTED]> 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..
