Re: new install, can't use - need password for postgres user

From: Douglas Hyde <dhyde(at)natureserve(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: new install, can't use - need password for postgres user
Date: 2011-08-12 12:59:42
Message-ID: A26F4C8D-3B15-4C91-AD58-B29686F64197@natureserve.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks though it appears it is all my fault. I did indeed set up a password at install, and it was windows security policy that forced me to use something I normally wouldn't, hence the reason I forgot it. I can see how your solution below would work, but I suspect at some point, it will be better to know what that password is.

So, after a reinstall, I am up and running. Thanks for everything.

Cheers,

Doug

> > So, I need a password. I tried several passwords, and none
> > worked...did I set this password on install? If yes, then my bad and
> > I will have to resintall, because I just don't remember what it was.
> > Then I guess I am kind of dumb, though in my defence, I first
> > installed this a month ago and I am just getting back to it now.
>
> You don't have to reinstall. I have a password for my postgresql. I tried a few combination of entries and this one seems to work and lets me through without a password from localhost.
> Can you try this?
> host all postgres 127.0.0.1/32 trust
>
> And you don't have to restart the server.
>
> Regards,
> Jayadevan
>
>
>
>
>
>
> DISCLAIMER:
>
> "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."
>
>
>
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message raghu ram 2011-08-12 19:35:28 Re: Alter table to add foreign key
Previous Message Jayadevan M 2011-08-12 12:32:40 Re: new install, can't use - need password for postgres user