我按照此文档上的安装步骤安装了PostgreSQL,一切看起来都很顺利。但当我尝试按照这篇教程进行操作时,出现了问题。创建数据库表时,我遇到了以下错误:
$ createdb mydb
WARNING: password file "/home/.../.pgpass" has group or world access; permissions should be u=rw (0600) or less
WARNING: password file "/home/.../.pgpass" has group or world access; permissions should be u=rw (0600) or less
createdb: could not connect to database template1: FATAL: role "..." does not exist
$ /usr/local/pgsql/bin/createdb mydb
bash: /usr/local/pgsql/bin/createdb: No such file or directory
createdb
必须在 bash 中运行,它不是 SQL 语句。create database
是要在psql
中运行的 SQL 语句。 - user330315