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