Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit22d233b

Browse files
committed
doc: clarify hierarchy of objects: global, db, schema, etc.
The previous wording was confusing because it wasn't in decreasing orderand had to backtrack. Also clarify role/user wording.Reported-by: jbird@nuna.comDiscussion:https://postgr.es/m/158057750885.1123.2806779262588618988@wrigleys.postgresql.orgBackpatch-through: 9.5
1 parentf086264 commit22d233b

File tree

2 files changed

+14
-17
lines changed

2 files changed

+14
-17
lines changed

‎doc/src/sgml/ddl.sgml‎

Lines changed: 7 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -2618,19 +2618,18 @@ SELECT * FROM information WHERE group_id = 2 FOR UPDATE;
26182618
</indexterm>
26192619

26202620
<para>
2621-
A <productname>PostgreSQL</productname> database cluster
2622-
contains one or more named databases. Users and groups of users are
2623-
shared across the entire cluster, but no other data is shared across
2624-
databases. Any given client connection to the server can access
2625-
only the data in a single database, the one specified in the connection
2626-
request.
2621+
A <productname>PostgreSQL</productname> database cluster contains
2622+
one or more named databases. Roles and a few other object types are
2623+
shared across the entire cluster. A client connection to the server
2624+
can only access data in a single database, the one specified in the
2625+
connection request.
26272626
</para>
26282627

26292628
<note>
26302629
<para>
26312630
Users of a cluster do not necessarily have the privilege to access every
2632-
database in the cluster. Sharing ofuser names means that there
2633-
cannot be differentusers named, say, <literal>joe</literal> in two databases
2631+
database in the cluster. Sharing ofrole names means that there
2632+
cannot be differentroles named, say, <literal>joe</literal> in two databases
26342633
in the same cluster; but the system can be configured to allow
26352634
<literal>joe</literal> access to only some of the databases.
26362635
</para>

‎doc/src/sgml/manage-ag.sgml‎

Lines changed: 7 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -22,15 +22,13 @@
2222
</indexterm>
2323

2424
<para>
25-
A database is a named collection of <acronym>SQL</acronym> objects
26-
(<quote>database objects</quote>). Generally, every database
27-
object (tables, functions, etc.) belongs to one and only one
28-
database. (However there are a few system catalogs, for example
29-
<literal>pg_database</literal>, that belong to a whole cluster and
30-
are accessible from each database within the cluster.) More
31-
accurately, a database is a collection of schemas and the schemas
32-
contain the tables, functions, etc. So the full hierarchy is:
33-
server, database, schema, table (or some other kind of object,
25+
A small number of objects, like role, database, and tablespace
26+
names, are defined at the cluster level and stored in the
27+
<literal>pg_global</literal> tablespace. Inside the cluster are
28+
multiple databases, which are isolated from each other but can access
29+
cluster-level objects. Inside each database are multiple schemas,
30+
which contain objects like tables and functions. So the full hierarchy
31+
is: cluster, database, schema, table (or some other kind of object,
3432
such as a function).
3533
</para>
3634

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp