Thread: Configure my server

On 26/11/2022 13:46, William Torrez Corea wrote:
> I want make a connection but this fail:
> 
> I get the following message:
> 
>     *Unable to connect to server connection to server at "localhost" (::1),*
> 
>     * port 5432 failed: FATAL: password authentication failed for user
>     *
> 
>     * "willitc9888" connection to server at "localhost" (::1), port 5432


This is coming from the server (or at least from whatever client library 
pgAdmin uses to communicate with the server), not from pgAdmin itself - 
it's the standard message you get when the wrong password is supplied.

Make sure that you have entered the correct password for (database user) 
"willitc9888".

Ray.


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

On 26/11/2022 18:10, William Torrez Corea wrote:
> Where can I change the username and password?

On the server or in pgAdmin?

On the server, you execute:

   alter role willitc9888 password 'super-secret-password';

In pgAdmin, you first need to clear whatever password is already saved 
for this server, then set the new one. Right-click the server in the 
tree-view on the left, and click "Clear saved password"; when that's 
done, right-click the server once again, select "Properties", then the 
"Connection" tab, and the password field should be there.

Hope this helps,

Ray.


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie