Re: Problems with authentication - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problems with authentication
Date
Msg-id 17132.979747553@sss.pgh.pa.us
Whole thread Raw
In response to Problems with authentication  (Orlando Eloy Gentil <gentil@cdludi.com.br>)
List pgsql-novice
Orlando Eloy Gentil <gentil@cdludi.com.br> writes:
>         After this when I try to use "psql -u -d postgres" or "psql -u",
> it
>  says that connection to database failed and failed authentication.
>     My Postmaster starts OK with -S -i -p 5432....
>     What can be happening?

Can't tell from that much info.  The postmaster's log output might tell
more about why it's refusing the connection.  Right now you are sending
that log to the bit bucket, however :-(.  Restart the postmaster
*without* -S, and with output redirection, eg
    postmaster -i -p 5432 ... >/path/to/handy/logfile 2>&1 &
and then see what it puts in the logfile when you try to connect.

BTW, you do not need to restart the postmaster after changing
pg_hba.conf.

            regards, tom lane

pgsql-novice by date:

Previous
From: Peter Rodriguez
Date:
Subject: Table recognition
Next
From: Nabil Sayegh
Date:
Subject: Re: LIKE optimization