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

From: Neil Anderson <neil(at)postgrescompare(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Melvin Davidson <melvin6925(at)gmail(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 19:13:36
Message-ID: CAEKCySv+y7_Typ0=UNTcBZxAFEzCTgX9iCAbFj7ufgtaKfYRiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> 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:
>

I think he was using server in the server=one machine sense, ie a
single machine/server can have multiple clusters/database servers.

> 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

--
Neil Anderson
neil(at)postgrescompare(dot)com
https://www.postgrescompare.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-05-28 19:22:07 Re: SELECT statement with sub-queries
Previous Message Neil Anderson 2017-05-28 19:11:10 Re: Help with terminology to describe what my software does please?