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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.