Entrar Ainda não tem acesso?
3
respostas

password authentication failed for user "postgres"

Referente ao curso PostgreSQL, no capítulo Primeiros passos com PostgreSQL e atividade Ambiente e versões

por Kaio miguel ruiz
| 83.2k xp | 87 posts

Tento colocar a senha, mas não sai nada quando digito e se dou enter, dá erro. 

Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
Password for user postgres:
psql: error: FATAL:  password authentication failed for user "postgres"
Pressione qualquer tecla para continuar. . .
3 respostas
por Danielle Oliveira
| 2147.2k xp | 4259 posts
Instrutor Instrutora

Olá, Kaio, tudo bem?

Quando a senha é digitada não aparece nada no terminal (nem os *), então você precisa digitar a sua senha completa e pressionar ENTER.

  • Você está conseguindo acessar normalmente pelo pgAdmin?

Aguardo o seu retorno!

por Kaio miguel ruiz
| 83.2k xp | 87 posts

NO PG ADM DA ESSE ERRO

pgAdmin Runtime Environment

Python Path: "C:\Program Files\PostgreSQL\14\pgAdmin 4\python\python.exe" Runtime Config File: "C:\Users\kaior\AppData\Roaming\pgadmin\runtime_config.json" pgAdmin Config File: "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\config.py" Webapp Path: "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgAdmin4.py" pgAdmin Command: "C:\Program Files\PostgreSQL\14\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgAdmin4.py" Environment:

  • ALLUSERSPROFILE: C:\ProgramData
  • APPDATA: C:\Users\kaior\AppData\Roaming
  • CHROME_CRASHPAD_PIPE_NAME: \.\pipe\crashpad_2016_XOUODGAUFBSMPHWS
  • CHROME_RESTART: NW.js|O NW.js travou. Reiniciar agora?|LEFT_TO_RIGHT
  • CommonProgramFiles: C:\Program Files\Common Files
  • CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  • CommonProgramW6432: C:\Program Files\Common Files
  • COMPUTERNAME: DESKTOP-G65ACUC
  • ComSpec: C:\WINDOWS\system32\cmd.exe
  • DriverData: C:\Windows\System32\Drivers\DriverData
  • GDAL_DATA: C:\Program Files\PostgreSQL\14\gdal-data
  • HOMEDRIVE: C:
  • HOMEPATH: \Users\kaior
  • LOCALAPPDATA: C:\Users\kaior\AppData\Local
  • LOGONSERVER: \DESKTOP-G65ACUC
  • MSMPI_BENCHMARKS: C:\Program Files\Microsoft MPI\Benchmarks\
  • MSMPI_BIN: C:\Program Files\Microsoft MPI\Bin\
  • NUMBER_OF_PROCESSORS: 4
  • OneDrive: C:\Users\kaior\OneDrive
  • OneDriveConsumer: C:\Users\kaior\OneDrive
  • OPENSSL_CONF: C:\Program Files\PostgreSQL\psqlODBC\etc\openssl.cnf
  • OS: Windows_NT
  • Path: C:\Program Files\Microsoft MPI\Bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Program Files\Git\cmd;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn;C:\Program Files\Microsoft SQL Server\150\Tools\Binn;C:\Program Files\Microsoft SQL Server\150\DTS\Binn;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn;C:\Program Files\Azure Data Studio\bin;C:\Users\kaior\AppData\Local\Microsoft\WindowsApps;;C:\Users\kaior\AppData\Local\Programs\Microsoft VS Code\bin;C:\Program Files\Azure Data Studio\bin;C:\Program Files\Azure Data Studio\bin
  • PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  • PGADMIN_INT_KEY: a909db55-5b65-4c59-9967-58fc67b0428f
  • PGADMIN_INT_PORT: 5050
  • PGADMIN_SERVER_MODE: OFF
  • POSTGIS_ENABLE_OUTDB_RASTERS: 1
  • POSTGIS_GDAL_ENABLED_DRIVERS: GTiff PNG JPEG GIF XYZ DTED USGSDEM AAIGrid
  • PROCESSOR_ARCHITECTURE: AMD64
  • PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 58 Stepping 9, GenuineIntel
  • PROCESSOR_LEVEL: 6
  • PROCESSOR_REVISION: 3a09
  • ProgramData: C:\ProgramData
  • ProgramFiles: C:\Program Files
  • ProgramFiles(x86): C:\Program Files (x86)
  • ProgramW6432: C:\Program Files
  • PROJ_LIB: C:\Program Files\PostgreSQL\14\share\contrib\postgis-3.1\proj
  • PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\
  • PUBLIC: C:\Users\Public
  • SESSIONNAME: Console
  • SystemDrive: C:
  • SystemRoot: C:\WINDOWS
  • TEMP: C:\Users\kaior\AppData\Local\Temp
  • TMP: C:\Users\kaior\AppData\Local\Temp
  • USERDOMAIN: DESKTOP-G65ACUC
  • USERDOMAIN_ROAMINGPROFILE: DESKTOP-G65ACUC
  • USERNAME: kaior
  • USERPROFILE: C:\Users\kaior
  • windir: C:\WINDOWS
por Danielle Oliveira
| 2147.2k xp | 4259 posts
Instrutor Instrutora

Não consegui compreender muito bem o erro retornado Kaio, você poderia fornecer mais detalhes?

  • Quando esse ocorre no pgAdmin?
  • Mesmo informando a senha correta no PSQL o erro (error: FATAL: password authentication failed for user "postgres") permanece?

Aguardo o seu retorno!