Postgresql服务器上名为postgres的默认数据库 [英] Default database named postgres on Postgresql server

问题描述

显然，在每个postgresql服务器安装中都有默认创建的数据库 postgres。谁能告诉我或指出我的文档用途是什么？

Apparently there is a database "postgres" that is created by default on each postgresql server installation. Can anyone tell me or point me to documentation what it is used for?

推荐答案

看来它并没有真正的优点。定义的目的。根据文档：

It appears that it does not really have a well-defined purpose. According to the docs:

创建数据库集群包括创建数据库数据将驻留在其中的目录，生成共享目录表（属于整个集群而不是任何特定数据库的表），并创建 template1和 postgres数据库。

Creating a database cluster consists of creating the directories in which the database data will live, generating the shared catalog tables (tables that belong to the whole cluster rather than to any particular database), and creating the "template1" and "postgres" databases.

[...]

postgres数据库是默认数据库，供用户，实用程序和第三方应用程序。

The postgres database is a default database meant for use by users, utilities and third party applications.

（来源： http://www.postgresql.org/docs/current/app-initdb.html ）

这篇关于Postgresql服务器上名为postgres的默认数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！