Re: Help with terminology to describe what my software does please?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Neil Anderson <neil(at)postgrescompare(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help with terminology to describe what my software does please?
Date: 2017-05-28 15:18:42
Message-ID: 10217862-acc8-7b3c-2dd3-79252522ae5b@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/28/2017 07:53 AM, Melvin Davidson wrote:
>
>

>

>
> Cluster comparison would only occur if you have two or more clusters on
> the same server, although it's possible to compare across servers,

Explain, because as I understand it a server = one cluster:

https://www.postgresql.org/docs/9.6/static/app-pg-ctl.html

"The init or initdb mode creates a new PostgreSQL database cluster. A
database cluster is a collection of databases that are managed by a
single server instance. This mode invokes the initdb command. See initdb
for details."

> but that would involve a lot more work. AFAIK, the only differences for
> a cluster would be:
> 1. PostgreSQL version
> 2. path to database
> 3. database users (note: it is also possible to make users database
> specific)
> 4. list of defined databases

And anything different below the above, I am thinking checking a dev
cluster against a production cluster.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2017-05-28 15:41:24 Re: Postgres 10 Beta1 - pg_upgrade fails on Windows 10
Previous Message Tom Lane 2017-05-28 15:13:31 Re: Help with terminology to describe what my software does please?