安装postgresql后,我试了一下,输入createdb mydb,就像文档里写的一样.然后出现如下错误:
After installing postgresql, I tried it out, typing createdb mydb, like it's written in the documentation. Then the following error occured:
createdb: could not connect to database postgres: FATAL: role "xxx" does not exist我研究了文档,其中说:
I studied the documentation, where is said:
您需要成为安装 PostgreSQL 的操作系统用户(通常是 postgres)才能创建第一个用户帐户
You will need to become the operating system user under which PostgreSQL was installed (usually postgres) to create the first user account
我通过访问 psql(在我的例子中使用 sudo -u postgres psql,使用 Ubuntu 12.10)来尝试这个.但那我该怎么办?
I tried this by accessing psql (in my case with sudo -u postgres psql, using Ubuntu 12.10). But then what should I do?
推荐答案如果数据库归用户 postgres 所有,您可以执行以下操作
if the db is owned by user postgres you can do the following
createdb -U postgres 数据库名
因为默认情况下 postgresql 将信任来自本地主机的连接.
since by default postgresql will trust connections from localhost.
更多推荐
Postgresql 初始配置:如何以 postgres 用户身份访问?
发布评论