PostgreSQL database "instance" or "cluster"?
"Tabitha McNerney" <[email protected]>
| Newsgroups | gmane.os.opendarwin.darwinports |
|---|---|
| Message-ID | <[email protected]> |
Hello all --
I have noticed that the Postgres Darwin Ports port files have post-install
instructions that, to the best of my interpretation, use incorrect language
(but please check me on this).
For example, the postgresql8 Portfile (for 8.1.3) post-install states ...
http://www.darwinports.org/darwinports/dports/databases/postgresql8/Portfile
> post-install {
> ui_msg "\nTo create a database instance, after install do\n\
> sudo mkdir -p ${dbdir}\n\
> sudo chown ${dbuser}:${dbgrp} ${dbdir}\n\
> sudo su ${dbuser} -c \'${libdir}/bin/initdb -D ${dbdir}\'"
>
>
Taking a look at the PostgreSQl 8.1 documentation, we have ...
http://www.postgresql.org/docs/8.1/interactive/app-initdb.html
initdb -- create a new PostgreSQL database cluster
Synopsis
initdb [*option*...] --pgdata | -D *directory*
Description
initdb creates a new PostgreSQL database cluster. A database cluster is a
collection of databases that are managed by a single server instance.
initdb most decidedly does not create a database instance but creates a
cluster.
The language is also found in ...
http://www.darwinports.org/darwinports/dports/databases/postgresql81-server/Portfile
and
http://www.darwinports.org/darwinports/dports/databases/postgresql7/Portfile
and
http://www.darwinports.org/darwinports/dports/databases/postgresql/Portfile
I move to suggest that the word instance is struck from these Portfiles and
replaced with cluster. Unless I am misunderstanding?
I discovered this discrepancy after installing the 8.1.3 (plus server
variant) Portfile and when I tried to connect to a database (I presumed one
named "postgres8" existed as part of the server installation), I received a
FATAL error stating that there was no such database. This makes sense since
its a cluster not an instance. Also I didn't want to add this to Bugzilla
until some others here on the list checked me, in consensus, to make sure
that I have not misinterpreted the semantics of instance and cluster as
federated to the PostgreSQL 8.x documentation.
Best regards to all,
T.