blocks|key|2509550|text|您的包管理器似乎未能为您创建名为$user的数据库。原因是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2509551|psql+-d+template1|code-block|syntax|javascript|2509552|template1是一个由postgres自己创建的数据库，它存在于所有安装中。显然，您能够登录到template1，因此您必须拥有由数据库分配给您的一些权限。在shell提示符下尝试如下：|2509553|createdb|2509554|然后看看是否可以再次登录|2509555|psql+-h+localhost|2509556|这将简单地为您的登录用户创建一个数据库，我认为这就是您要寻找的。如果createdb失败了，那么您就没有足够的权限创建您自己的数据库，您将不得不弄清楚如何修复自制的包。|2509557|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

It appears that your package manager failed to create the database named $user for you. The reason that

<pre><code>psql -d template1
</code></pre>

works for you is that template1 is a database created by postgres itself, and is present on all installations.
You are apparently able to log in to template1, so you must have some rights assigned to you by the database. Try this at a shell prompt:

<pre><code>createdb
</code></pre>

and then see if you can log in again with 

<pre><code>psql -h localhost
</code></pre>

This will simply create a database for your login user, which I think is what you are looking for. If createdb fails, then you don't have enough rights to make your own database, and you will have to figure out how to fix the homebrew package.

blocks|key|112751|text|默认情况下，postgres尝试连接到与用户同名的数据库。要防止这种默认行为，只需指定用户和数据库：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|112752|psql+-U+Username+DatabaseName+|code-block|syntax|javascript|112753|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

By default, postgres tries to connect to a database with the same name as your user. To prevent this default behaviour, just specify user and database:

<pre><code>psql -U Username DatabaseName 
</code></pre>

blocks|key|1191793|text|在使用homebrew安装postgresql之后，我仍然遇到了上面的问题--我解决了它，在/usr/bin之前将/usr/local/bin放在我的路径中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1191794|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I still had the issue above after installing postgresql using homebrew - I resolved it by putting /usr/local/bin in my path before /usr/bin

blocks|key|2509657|text|由于这个问题是搜索结果中的第一个问题，为了避免重复标题，我将在这里为不同的问题提供不同的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2509658|在不指定数据库的情况下，在psql中运行查询文件时也会出现相同的错误消息。由于postgresql中没有use语句，所以我们必须在命令行上指定数据库，例如：|offset|length|style|CODE|2509659|psql+-d+db_name+-f+query_file.sql|code-block|syntax|javascript|2509660|entityMap^0|0|D|4|1G|3|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]|$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|U|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

Since this question is the first in search results, I'll put a different solution for a different problem here anyway, in order not to have a duplicate title.

The same error message can come up when running a query file in <code>psql</code> without specifying a database. Since there is no <code>use</code> statement in postgresql, we have to specify the database on the command line, for example:

<pre><code>psql -d db_name -f query_file.sql
</code></pre>

blocks|key|112809|text|如果环境变量PGDATABASE设置为不存在的数据库的名称，也会发生此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|112810|在OSX上，我在尝试从Postgress.app菜单启动psql时看到了以下错误：|112811|psql:+FATAL:++database+"otherdb"+does+not+exist|offset|length|style|CODE|112812|解决此错误的方法是从export+PGDATABASE=otherdb中删除~/.bash_profile。|112813|此外，如果PGUSER设置为用户名以外的其他内容，则会发生以下错误：|112814|psql:+FATAL:++role+"note"+does+not+exist|112815|解决方案是从export+PGUSER=notme中删除~/.bash_profile。|112816|entityMap^0|0|0|0|1B|0|A|P|12|F|0|0|0|14|0|6|J|S|F|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@$F|W|G|X|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@$F|Z|G|10|H|I]|$F|11|G|12|H|I]]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|14|8|@$F|15|G|16|H|I]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|17|8|@$F|18|G|19|H|I]|$F|1A|G|1B|H|I]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|S|$]]

This error can also occur if the environment variable PGDATABASE is set to the name of a database that does not exist.

On OSX, I saw the following error while trying to launch psql from the Postgress.app menu:

<code>psql: FATAL: database "otherdb" does not exist</code>

The solution to the error was to remove <code>export PGDATABASE=otherdb</code> from <code>~/.bash_profile</code>:

Further, if PGUSER is set to something other than your username, the following error will occur:

<code>psql: FATAL: role "note" does not exist</code>

The solution is to remove <code>export PGUSER=notme</code> from <code>~/.bash_profile</code>.

blocks|key|1191882|text|在使用JDBC驱动程序时遇到了问题，因此只需在URL中主机名之后添加数据库(可能需要根据您可能使用的工具冗余)，例如jdbc:postgres://<host(:port)>/<db-name>。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|1191883|更多的详细信息记录在这里：http://www.postgresql.org/docs/7.4/static/jdbc-use.html#JDBC-CONNECT|1191884|entityMap|0|LINK|mutability|MUTABLE|url|http://www.postgresql.org/docs/7.4/static/jdbc-use.html#JDBC-CONNECT^0|1M|13|1M|13|0|D|1W|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|D]]|E|@]|F|$]]|$1|G|3|H|5|6|7|V|8|@]|E|@$9|W|A|X|1|Y]]|F|$]]|$1|I|3|-4|5|6|7|Z|8|@]|E|@]|F|$]]]|J|$K|$5|L|M|N|F|$O|P]]]]

had the problem with using the JDBC driver, so one just has to add the database (maybe redundantly depending on the tool you may use) after the host name in the URL, e.g.
<code>jdbc:postgres://&lt;host(:port)&gt;/&lt;db-name&gt;</code>

further details are documented here: <a href="http://www.postgresql.org/docs/7.4/static/jdbc-use.html#JDBC-CONNECT" rel="nofollow">http://www.postgresql.org/docs/7.4/static/jdbc-use.html#JDBC-CONNECT</a>

blocks|key|1191916|text|以默认用户身份登录：sudo+-i+-u+postgres|type|ordered-list-item|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1191917|创建新用户：createuser+--interactive|1191918|当提示输入角色名称时，输入linux，并选择Yes+to+superuser问句。|1191919|仍然以postgres用户身份登录，创建一个数据库：createdb+<username_from_step_3>|1191920|通过在命令提示符处输入：psql，确认错误已经消失。|1191921|输出应该显示psql+(x.x.x)+Type+"help"+for+help.|1191922|unstyled|entityMap^0|A|J|0|6|O|0|0|Q|V|0|C|4|0|6|Y|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|Y|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|P|3|-4|5|Q|7|18|8|@]|D|@]|E|$]]]|R|$]]

<ol>
<li>Login as default user: <code>sudo -i -u postgres</code></li>
<li>Create new User: <code>createuser --interactive</code></li>
<li>When prompted for role name, enter linux username, and select Yes to superuser question.</li>
<li>Still logged in as postgres user, create a database: <code>createdb &lt;username_from_step_3&gt;</code></li>
<li>Confirm error(s) are gone by entering: <code>psql</code> at the command prompt.</li>
<li>Output should show <code>psql (x.x.x) Type "help" for help.</code></li>
</ol>

blocks|key|1191927|text|使用默认template1数据库登录：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1191928|#psql+-d+template1
#template1=#+\l

++List+of+databases
+++Name++++%7C++Owner++%7C+Encoding+%7C+++Collate+++%7C++++Ctype++++%7C++Access+privileges++
-----------%2B---------%2B----------%2B-------------%2B-------------%2B---------------------
+postgres++%7C+gogasca+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+
+template0+%7C+gogasca+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+=c/gogasca+++++++++%2B
+++++++++++%7C+++++++++%7C++++++++++%7C+++++++++++++%7C+++++++++++++%7C+gogasca=CTc/gogasca
+template1+%7C+gogasca+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+=c/gogasca+++++++++%2B
+++++++++++%7C+++++++++%7C++++++++++%7C+++++++++++++%7C+++++++++++++%7C+gogasca=CTc/gogasca
(3+rows)|code-block|syntax|javascript|1191929|使用userId创建一个数据库：|1191930|template1=#+CREATE+DATABASE+gogasca+WITH+OWNER+gogasca+ENCODING+'UTF8';
CREATE+DATABASE|1191931|退出，然后再次登录|1191932|template1=#+\q
gonzo:~+gogasca$+psql+-h+localhost
psql+(9.4.0)
Type+"help"+for+help.

gogasca=#+\l
++++++++++++++++++++++++++++++++List+of+databases
+++Name++++%7C++Owner++%7C+Encoding+%7C+++Collate+++%7C++++Ctype++++%7C++Access+privileges++
-----------%2B---------%2B----------%2B-------------%2B-------------%2B---------------------
+gogasca+++%7C+gogasca+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+
+postgres++%7C+gogasca+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+
+template0+%7C+gogasca+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+=c/gogasca+++++++++%2B
+++++++++++%7C+++++++++%7C++++++++++%7C+++++++++++++%7C+++++++++++++%7C+gogasca=CTc/gogasca
+template1+%7C+gogasca+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+=c/gogasca+++++++++%2B
+++++++++++%7C+++++++++%7C++++++++++%7C+++++++++++++%7C+++++++++++++%7C+gogasca=CTc/gogasca
(4+rows)|1191933|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

blocks|key|1192026|text|正如createdb文件所说：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1192027|当数据存储区域初始化时，第一个数据库总是由initdb命令创建的。这个数据库叫做postgres。|blockquote|1192028|因此，如果某些OS/postgresql发行版以不同的方式执行，则肯定不是默认/标准(刚刚验证了initdb+on+openSUSE+13.1创建DB+"postgres"，而不是"")。长话短说，在使用"postgres“以外的用户时，预计将使用psql+-d+postgres。|style|CODE|1192029|显然，可以接受的答案是运行createdb来创建一个与用户类似的DB，但也会创建一个多余的DB。|1192030|entityMap|0|LINK|mutability|MUTABLE|url|http://www.postgresql.org/docs/9.3/static/manage-ag-createdb.html^0|2|A|0|0|0|1C|6|3G|G|0|D|8|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|Z|8|@$A|10|B|11|I|J]|$A|12|B|13|I|J]]|9|@]|C|$]]|$1|K|3|L|5|6|7|14|8|@$A|15|B|16|I|J]]|9|@]|C|$]]|$1|M|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

As the <a href="http://www.postgresql.org/docs/9.3/static/manage-ag-createdb.html" rel="noreferrer">createdb documentation</a> states:

<blockquote>
 The first database is always created by the initdb command when the data storage area is initialized... This database is called postgres.
</blockquote>

So if certain OS/postgresql distributions do that differently, it is certainly not the default/standard (just verified that <code>initdb</code> on openSUSE 13.1 creates the DB "postgres", but not "&lt;user&gt;"). Long story short, <code>psql -d postgres</code> is expected to be used when using a user other than "postgres".

Obviously the accepted answer, running <code>createdb</code> to create a DB named like the user, works as well, but creates a superfluous DB.

blocks|key|2509805|text|这是一个基本的误解。只需输入：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2509806|pgres|blockquote|2509807|将导致这一反应：|2509808|pgres+<db_name>+|code-block|syntax|javascript|2509809|如果用户拥有访问db的权限，它将获得成功，而不会出错。|2509810|可以详细介绍导出的环境变量，但这是不必要的。这太基本了，不可能因为任何其他原因而失败。|2509811|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|T|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|U|8|@]|9|@]|A|$J|K]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|W|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|Q|$]]

This is a basic misunderstanding. Simply typing:
<blockquote>
pgres
</blockquote>
will result in this response:
<pre><code>pgres &lt;db_name&gt; 
</code></pre>
It will succeed without error if the user has the permissions to access the db.
One can go into the details of the exported environment variables but that's unnecessary .. this is too basic to fail for any other reason.

blocks|key|112961|text|首先，创建一个与当前使用相同的数据库是很有帮助的，当您只想使用默认数据库并创建新表而不显式声明数据库名称时，就可以防止出现错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|112962|将“天际通知”改为您的用户名：|112963|psql+-d+postgres+-c+"CREATE+DATABASE+skynotify+ENCODING+'UTF-8';"|code-block|syntax|javascript|112964|-d显式声明要使用哪个数据库作为在此交互会话期间不显式包含数据库名称的SQL语句的缺省值。|112965|了解PostgresQL服务器中包含哪些内容的基本知识。|112966|必须连接到现有数据库，才能交互地使用psql。幸运的是，您可以向psql请求一个数据库列表：|112967|psql+-l|112968|。|112969|++++++++++++++++++++++++++++++++++++++++++List+of+databases
+++++++++++++++Name+++++++++++++++%7C+Owner++%7C+Encoding+%7C+++Collate+++%7C++++Ctype++++%7C+Access+privileges+
----------------------------------%2B-----------%2B----------%2B-------------%2B-------------%2B-------------------
+skynotify++++++++++++++++++++++++%7C+skynotify+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+
+myapp_dev++++++++++++++++++++++++%7C+skynotify+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+
+postgres+++++++++++++++++++++++++%7C+skynotify+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+
+ruby-getting-started_development+%7C+skynotify+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+
+template0++++++++++++++++++++++++%7C+skynotify+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+=c/skynotify++++++++++%2B
++++++++++++++++++++++++++++++++++%7C+++++++++++%7C++++++++++%7C+++++++++++++%7C+++++++++++++%7C+skynotify=CTc/skynotify
+template1++++++++++++++++++++++++%7C+skynotify+%7C+UTF8+++++%7C+en_US.UTF-8+%7C+en_US.UTF-8+%7C+=c/skynotify++++++++++%2B
++++++++++++++++++++++++++++++++++%7C+++++++++++%7C++++++++++%7C+++++++++++++%7C+++++++++++++%7C+skynotify=CTc/skynotify
(6+rows)|112970|这不会启动交互控制台，它只是将基于文本的表输出到终端。|112971|正如另一个答案所述，postgres总是被创建的，所以当您只想让控制台开始在其他数据库上工作时，应该将它用作您的故障安全数据库。如果没有，那么列出数据库，然后使用其中的任何一个。|112972|以类似的方式，从数据库中选择表：|112973|psql+-d+postgres+-c+"\dt;"|112974|我的"postgres“数据库没有表，但是任何数据库都会将基于文本的表输出到终端(标准输出)。|112975|为了完整起见，我们也可以从一个表中选择所有行：|112976|psql+-d+ruby-getting-started_development+-c+"SELECT+*+FROM+widgets;"|112977|112978|+id+%7C+name+%7C+description+%7C+stock+%7C+created_at+%7C+updated_at+
----%2B------%2B-------------%2B-------%2B------------%2B------------
(0+rows)|112979|即使返回零行，也会得到字段名。|112980|如果您的表有十多行，或者您不确定，那么从行数开始了解数据库中有多少数据会更有用：|112981|+psql+-d+ruby-getting-started_development+-c+"SELECT+count(*)+FROM+widgets;"|112982|112983|+count+
-------
+++++0
(1+row)|112984|不要把"1行“搞混了，它只是表示查询返回了多少行，但是1行包含您想要的计数，在本例中为0。|112985|注意:未定义所有者的数据库将由当前用户拥有。|112986|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1V|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1W|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|1X|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1Y|8|@]|9|@]|A|$G|H]]|$1|U|3|V|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|20|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|21|8|@]|9|@]|A|$]]|$1|10|3|11|5|F|7|22|8|@]|9|@]|A|$G|H]]|$1|12|3|13|5|6|7|23|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|24|8|@]|9|@]|A|$]]|$1|16|3|17|5|F|7|25|8|@]|9|@]|A|$G|H]]|$1|18|3|R|5|6|7|26|8|@]|9|@]|A|$]]|$1|19|3|1A|5|F|7|27|8|@]|9|@]|A|$G|H]]|$1|1B|3|1C|5|6|7|28|8|@]|9|@]|A|$]]|$1|1D|3|1E|5|6|7|29|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|F|7|2A|8|@]|9|@]|A|$G|H]]|$1|1H|3|R|5|6|7|2B|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|F|7|2C|8|@]|9|@]|A|$G|H]]|$1|1K|3|1L|5|6|7|2D|8|@]|9|@]|A|$]]|$1|1M|3|1N|5|6|7|2E|8|@]|9|@]|A|$]]|$1|1O|3|-4|5|6|7|2F|8|@]|9|@]|A|$]]]|1P|$]]

First off, it's helpful to create a database named the same as your current use, to prevent the error when you just want to use the default database and create new tables without declaring the name of a db explicitly.

Replace "skynotify" with your username:

<pre><code>psql -d postgres -c "CREATE DATABASE skynotify ENCODING 'UTF-8';"
</code></pre>

-d explicitly declares which database to use as the default for SQL statements that don't explicitly include a db name during this interactive session.

BASICS FOR GETTING A CLEAR PICTURE OF WHAT YOUR PostgresQL SERVER has in it.

You must connect to an existing database to use psql interactively. Fortunately, you can ask psql for a list of databases:

<pre><code>psql -l
</code></pre>

.

<pre><code> List of databases
 Name | Owner | Encoding | Collate | Ctype | Access privileges 
----------------------------------+-----------+----------+-------------+-------------+-------------------
 skynotify | skynotify | UTF8 | en_US.UTF-8 | en_US.UTF-8 | 
 myapp_dev | skynotify | UTF8 | en_US.UTF-8 | en_US.UTF-8 | 
 postgres | skynotify | UTF8 | en_US.UTF-8 | en_US.UTF-8 | 
 ruby-getting-started_development | skynotify | UTF8 | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | skynotify | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/skynotify +
 | | | | | skynotify=CTc/skynotify
 template1 | skynotify | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/skynotify +
 | | | | | skynotify=CTc/skynotify
(6 rows)
</code></pre>

This does NOT start the interactive console, it just outputs a text based table to the terminal. 

As another answers says, postgres is always created, so you should use it as your failsafe database when you just want to get the console started to work on other databases. If it isn't there, then list the databases and then use any one of them.

In a similar fashion, select tables from a database:

<pre><code>psql -d postgres -c "\dt;"
</code></pre>

My "postgres" database has no tables, but any database that does will output a text based table to the terminal (standard out).

And for completeness, we can select all rows from a table too:

<pre><code>psql -d ruby-getting-started_development -c "SELECT * FROM widgets;"
</code></pre>

.

<pre><code> id | name | description | stock | created_at | updated_at 
----+------+-------------+-------+------------+------------
(0 rows)
</code></pre>

Even if there are zero rows returned, you'll get the field names.

If your tables have more than a dozen rows, or you're not sure, it'll be more useful to start with a count of rows to understand how much data is in your database:

<pre><code> psql -d ruby-getting-started_development -c "SELECT count(*) FROM widgets;"
</code></pre>

.

<pre><code> count 
-------
 0
(1 row)
</code></pre>

And don't that that "1 row" confuse you, it just represents how many rows are returned by the query, but the 1 row contains the count you want, which is 0 in this example.

NOTE: a db created without an owner defined will be owned by the current user.

blocks|key|2509897|text|当我试图在mac上打开postgresql时，我也遇到了同样的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2509898|psql:+FATAL:++database+"user"+does+not+exist|code-block|syntax|javascript|2509899|我找到了一个简单的命令来解决这个问题：|2509900|method1|2509901|$+createdb+--owner=postgres+--encoding=utf8+user|2509902|和类型|2509903|+psql|2509904|方法2：|2509905|psql+-d+postgres|2509906|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

I faced the same error when I trying to open postgresql on mac

<pre><code>psql: FATAL: database "user" does not exist
</code></pre>

I found this simple command to solve it:

method1

<pre><code>$ createdb --owner=postgres --encoding=utf8 user
</code></pre>

and type

<pre><code> psql
</code></pre>

Method 2:

<pre><code>psql -d postgres
</code></pre>

blocks|key|2509932|text|通过自制安装postgresql时出现了此问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2509933|必须创建默认的"postgres“超级用户：|2509934|createuser+--交互式postgres答案y，用于超级用户
创建用户--超级用户的交互式用户答案y|blockquote|2509935|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|J|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|K|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|L|8|@]|9|@]|A|$]]]|H|$]]

Had this problem when installing postgresql via homebrew.

Had to create the default "postgres" super user with:

<blockquote>
 createuser --interactive postgres answer y to for super user
 
 createuser --interactive user answer y to for super user
</blockquote>

blocks|key|2509958|text|同样的问题，一个简单的psql+-d+postgres做了(在终端中键入命令)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2509959|entityMap^0|B|G|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Had the same problem, a simple <code>psql -d postgres</code> did it (Type the command in the terminal)

blocks|key|113155|text|通过现有超级用户连接到postgres。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|113156|通过连接到postgres的用户名创建数据库。|113157|create+database+username;|code-block|syntax|javascript|113158|现在尝试通过用户名连接|113159|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Connect to postgres via existing superuser.

Create a Database by the name of user you are connecting through to postgres.

<pre><code>create database username;
</code></pre>

Now try to connect via username

blocks|key|1192276|text|试着用-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1192277|psql+-d+postgres|offset|length|style|CODE|1192278|在运行psql时，我也面临着同样的问题|1192279|entityMap^0|0|0|G|0|3|4|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

Try using-

<code>psql -d postgres</code>

I was also facing the same issue when I ran <code>psql</code>

blocks|key|2510070|text|不确定它是否已经添加到答案中，Anatolii的答案非常有用，如下所示。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2510071|psql+-U+Username+postgres+#+when+you+have+no+databases+yet|code-block|syntax|javascript|2510072|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Not sure if it is already added in the answers, Anatolii Stepaniuk answer was very helpful which is the following.

<pre><code>psql -U Username postgres # when you have no databases yet
</code></pre>

blocks|key|1192317|text|Post安装postgres，在我的例子中版本是12.2，我运行了下面的命令createdb。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1192318|$+createdb+`whoami`

$+psql

psql+(12.2)
Type+"help"+for+help.

macuser=#+|code-block|syntax|javascript|1192319|entityMap^0|12|8|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Post installation of postgres, in my case version is 12.2, I did run the below command <code>createdb</code>.

<pre><code>$ createdb `whoami`

$ psql

psql (12.2)
Type "help" for help.

macuser=# 
</code></pre>

blocks|key|1192323|text|可以在env变量PGDATABASE=database_name中设置要连接的数据库名。如果不设置这个psql，默认的数据库名是用户名。设置好这个之后，您就不必创建b了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1192324|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

you can set the database name you want to connect to in env variable PGDATABASE=database_name. If you dont set this psql default database name is as username. after setting this you don't have to createdb

blocks|key|113242|text|步骤1:|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|113243|psql+-d+template1|CODE|113244|现在你应该在psql终端上|113245|步骤2:|113246|CREATE+DATABASE+username;|113247|确保在数据库名称之后使用分号(;)；|113248|可选:在psql终端上键入\ls或\l列出所有数据库；|113249|步骤3:|113250|psql+-h+localhost|113251|现在你应该连接起来；|113252|entityMap^0|0|4|0|0|H|0|0|0|4|0|0|P|0|0|D|3|H|2|0|0|4|0|0|H|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@$9|14|A|15|B|H]]|D|@]|E|$]]|$1|I|3|J|5|6|7|16|8|@]|D|@]|E|$]]|$1|K|3|L|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|1A|8|@$9|1B|A|1C|B|H]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1D|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1E|8|@$9|1F|A|1G|B|H]|$9|1H|A|1I|B|H]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1J|8|@$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|U|3|V|5|6|7|1M|8|@$9|1N|A|1O|B|H]]|D|@]|E|$]]|$1|W|3|X|5|6|7|1P|8|@]|D|@]|E|$]]|$1|Y|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]]|Z|$]]

Step 1:
<code>psql -d template1</code>
now you should be on psql terminal
Step 2:
<code>CREATE DATABASE username;</code>
make sure you use semicolon (;) after the database name;
optional: on psql terminal type <code>\ls</code> or <code>\l</code> to list all the databases;
Step 3:
<code>psql -h localhost</code>
now you should be connected;

blocks|key|113291|text|在码头经营postgres。在cli中，我得到错误"root“角色不存在。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|113292|苏-+postgres+psql|blockquote|113293|解决了问题。|113294|PostgreSQL在安装PostgreSQL时创建的系统上有自己的用户。postgres用户可以不使用密码就登录到PostgreSQL。没有其他用户能够登录到PostgreSQL。|113295|这意味着在使用PostgreSQL之前，需要使用以下命令切换到该用户帐户：|113296|这样，您就可以使用以下命令登录到PosgreSQL客户端：|113297|psql您将无法像任何其他用户一样从命令行访问数据库。|113298|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|S|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|T|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|U|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|V|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|W|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|P|$]]

Was running postgres in docker. In cli I was getting the error &quot;root&quot; role doesn't exist.
<blockquote>
su - postgres
</blockquote>
<blockquote>
psql
</blockquote>
solved the problem.
PostgreSQL has its own user on the system which is created when PostgreSQL is installed. The postgres user is able to log into PostgreSQL without using a password. No other user is able to log into PostgreSQL.
This means that before using PostgreSQL, you will need to switch to that user account with the command:
su - postgres
You will then be able to log into the PosgreSQL client with the command:
psql
You will not be able to access the database from the command line as any other user.

blocks|key|2510258|text|这对我解决这个问题起了作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2510259|我运行sudo+-i+-u+postgres+>以访问postgres数据库。|2510260|然后输入密码。|2510261|它允许您现在输入psql，这将提示您输入其他命令。|2510262|干杯!|2510263|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

This worked for me when solving this problem
i ran sudo -i -u postgress --&gt; to gain access to my postgres database.
Then enter your password.
it would allow you to now enter psql
which would prompt you for other command
Cheers!

I'm using the PostgreSql app for mac (<a href="http://postgresapp.com/" rel="noreferrer">http://postgresapp.com/</a>). I've used it in the past on other machines but it's giving me some trouble when installing on my macbook. I've installed the application and I ran:

<pre><code>psql -h localhost
</code></pre>

It returns:

<pre><code>psql: FATAL: database "&lt;user&gt;" does not exist
</code></pre>

It seems I can't even run the console to create the database that it's attempting to find. The same thing happens when I just run:

<pre><code>psql 
</code></pre>

or if I launch psql from the application drop down menu:

Machine stats:

<ul>
<li>OSX 10.8.4</li>
<li>psql (PostgreSQL) 9.2.4</li>
</ul>

Any help is appreciated. 

I've also attempted to install PostgreSql via homebrew and I'm getting the same issue. I've also read the applications documentation page that states: 

<blockquote>
 When Postgres.app first starts up, it creates the $USER database,
 which is the default database for psql when none is specified. The
 default user is $USER, with no password.
</blockquote>

So it would seem the application is not creating $USER however I've installed->uninstalled-reinstalled several times now so it must be something with my machine.

I found the answer but I'm not sure exactly how it works as the user who answered on this thread -> <a href="https://stackoverflow.com/questions/13515834/getting-postgresql-running-in-mac-database-postgres-does-not-exist">Getting Postgresql Running In Mac: Database &quot;postgres&quot; does not exist</a> didn't follow up. I used the following command to get psql to open: 

<pre><code>psql -d template1
</code></pre>

I'll leave this one unanswered until someone can provide an explanation for why this works.

psql: FATAL: database "<user>" does not exist

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我使用的是mac的PostgreSql应用程序()。我过去曾在其他机器上使用过它，但在我的macbook上安装时，它给我带来了一些麻烦。我已经安装了应用程序，我运行了：psql -h localhost它返回：psql: FATAL: database "<user>" does not exist似乎我甚至无法运行...

问psql:致命:数据库"<user>“不存在
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问psql:致命:数据库"<user>“不存在EN