我是新的postgressql
当我尝试使用命令创建的新数据库创建新数据库时
我有一个错误:
createb:error:在“ localhost”(:: 1),端口5432失败:致命的:密码身份验证失败的用户“ danie”
我找到了Windows上的解决方案的原因,这就是为什么IM创建此解决方案是为了帮助某人的原因, 首先有相同错误的错误,
您需要将postgressql命令添加到Windows CMD:
在Internet中搜索如何容易
第二,因为您可以看到错误是Windows用户名的身份验证失败,
因此您需要在PDADMIN4中创建一个具有Windows用户名相同名称的新用户:
在这里您可以知道
这是如何对我有用的
im new in postgresSQL
and when i try to create a new database with the command createdb
i got this error:
createdb: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "danie"
i found the solution on windows thats why im creating this for helping someone that have the same error
first you need to add the postgresSQl commands to windows cmd:
search in internet how, it is easy
second, as you can see the error is that authentication failed for your windows username
so you need to create a new user in pdAdmin4 with the same name of your windows username:
here you can know how
thats all, that work for me
发布评论
评论(1)
如何将PostGressQL添加到CMD窗口中?
首先,您需要将postgressql命令添加到Windows CMD:搜索Internet如何,很容易
第二,因为您可以看到错误是Windows用户名的身份验证失败了,
因此您需要在PDADMIN4中创建一个具有与Windows用户名相同名称的新用户:
在这里可以知道
这是如何对我有用的全部
how to add postgresSQL to the cmd windows?
https://linuxhint.com/connect-to-postgresql-database-command-line-windows/
first you need to add the postgresSQl commands to windows cmd: search in internet how, it is easy
second, as you can see the error is that authentication failed for your windows username
so you need to create a new user in pdAdmin4 with the same name of your windows username:
here you can know how
thats all, that work for me