Thread: i am getting issue as FATAL: password authentication failed for user' postgres' tried

i am getting issue as FATAL: password authentication failed for user' postgres' tried

From
prachi surangalikar
Date:
hello team,
i have  tried every  thing  but still i  could not find the solution to this problem.
i made changes in the pg_hba.conf file also , please help me to solve this problem.
On 6/17/20 7:14 PM, prachi surangalikar wrote:
> hello team,
> i have  tried every  thing  but still i  could not find the solution to 
> this problem.
> i made changes in the pg_hba.conf file also , please help me to solve 
> this problem.

What is the connection string you are using when you get the error?

What are the settings in the pg_hba.conf file?



-- 
Adrian Klaver
adrian.klaver@aklaver.com



On 6/17/20 7:14 PM, prachi surangalikar wrote:
> hello team,
> i have  tried every  thing  but still i  could not find the solution to 
> this problem.
> i made changes in the pg_hba.conf file also , please help me to solve 
> this problem.

Should have added to previous post:

Are you sure that you are using the correct password or that the 
'postgres' user has a password?

-- 
Adrian Klaver
adrian.klaver@aklaver.com



On Wed, Jun 17, 2020 at 9:14 PM prachi surangalikar
<surangalikarprachi100@gmail.com> wrote:
>
> hello team,
> i have  tried every  thing  but still i  could not find the solution to this problem.
> i made changes in the pg_hba.conf file also , please help me to solve this problem.

As  a noob to programming and under the hood stuff I have found myself
with this
issue a few times. My method to 'fix' this problem is likely not
sanctioned but as I'm
working on my system on my stuff - - - oh well it works even if its NOT elegant!

When my password for postgres doesn't work.
1. I try again a couple times
2. still not working I go back into the pg_hba.conf file and comment out
    the 'new' part where postgresql has moved from no password to password
3. next step is to stop and restart postgresql
4. now you log into postgresql and given postgres a password
    (I would suggest writing it down - - - - you need to remember it!!
     One technique I use is to have a password that I can refer to in some way
     where I don't write out the password. Say you might use something based
     on a specific bit of text. You write down the directions to that
text but not
     the actual password - - - the directions should be enough of a tip so that
     you can remember the actual password!)
5. now you again modify your pg_hbs.conf file to require a password

I will admit to having occasionally needing to do this a few times in
fairly quick
succession. Using this method (I don't remove the lines from the hb_pga.conf
file I just comment them out) has reduced my stress levels at least a little.
This may not be the most secure way of doing things but if your
cracker has access
to your machine to review conf files - - - - I'd say you have some large issues
happening already.

Regards



On 2020-06-17 20:00:51 -0700, Adrian Klaver wrote:
> On 6/17/20 7:14 PM, prachi surangalikar wrote:
> > i have  tried every  thing  but still i  could not find the solution to
> > this problem.
> > i made changes in the pg_hba.conf file also , please help me to solve
> > this problem.
>
> Should have added to previous post:
>
> Are you sure that you are using the correct password or that the 'postgres'
> user has a password?

And that the OP is indeed using the 'postgres' user and not the ' postgres'
user (as she wrote in the subject).

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment
On 6/22/20 9:18 PM, prachi surangalikar wrote:
Please relpy to list also.
Ccing lis.
> i  tried to connect to postgres using psql  and then its asking me 
> password for user 'administrator' but i have not created any 
> administrator user and when i logged in as user 'postgres' it is asking 
> for  password then when i entered password it said password 
> authentication failed for user 'postgres'.
> Even when i connect using pgadmin its giving the same error.

Are you running this on Windows and using the Enterprise DB download of 
Postgres?

If so when you installed Postgres the installer asked you to create a 
password. This is the password you need when connecting via pgAdmin. Now 
the 'administrator' could also mean the program(psql) needs to run as 
the Windows Administrator. Can you show the command you are running and 
where/when you being prompted for the password?

> 
> Do i need to change any configuration in pg_hba.conf file?
> or add the user 'administrator' in the conf file.
> 
> On Thu, Jun 18, 2020 at 8:25 AM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 6/17/20 7:14 PM, prachi surangalikar wrote:
>      > hello team,
>      > i have  tried every  thing  but still i  could not find the
>     solution to
>      > this problem.
>      > i made changes in the pg_hba.conf file also , please help me to
>     solve
>      > this problem.
> 
>     What is the connection string you are using when you get the error?
> 
>     What are the settings in the pg_hba.conf file?
> 
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



On Sat, Jun 20, 2020 at 06:28:52PM +0200, Peter J. Holzer wrote:
> On 2020-06-17 20:00:51 -0700, Adrian Klaver wrote:
> > On 6/17/20 7:14 PM, prachi surangalikar wrote:
> > > i have  tried every  thing  but still i  could not find the solution to
> > > this problem.
> > > i made changes in the pg_hba.conf file also , please help me to solve
> > > this problem.
> > 
> > Should have added to previous post:
> > 
> > Are you sure that you are using the correct password or that the 'postgres'
> > user has a password?
> 
> And that the OP is indeed using the 'postgres' user and not the ' postgres'
> user (as she wrote in the subject).

Uh, how are those different?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee




On 6/23/20 3:16 PM, Bruce Momjian wrote:
> On Sat, Jun 20, 2020 at 06:28:52PM +0200, Peter J. Holzer wrote:
>> On 2020-06-17 20:00:51 -0700, Adrian Klaver wrote:
>>> On 6/17/20 7:14 PM, prachi surangalikar wrote:
>>>> i have  tried every  thing  but still i  could not find the solution to
>>>> this problem.
>>>> i made changes in the pg_hba.conf file also , please help me to solve
>>>> this problem.
>>>
>>> Should have added to previous post:
>>>
>>> Are you sure that you are using the correct password or that the 'postgres'
>>> user has a password?
>>
>> And that the OP is indeed using the 'postgres' user and not the ' postgres'
>> user (as she wrote in the subject).
> 
> Uh, how are those different?
> 

Extra space.

It happens:


https://stackoverflow.com/questions/62541581/django-db-utils-operationalerror-fatal-password-authentication-failed-for-user

-- 
Adrian Klaver
adrian.klaver@aklaver.com