>> 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/serv
>
>
> Cluster comparison would only occur if you have two or more clusters on
> the same server, although it's possible to compare across servers,
> 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. datab
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/s
Neil Anderson writes:
> I guess I don't know what is the most common way to say that it
> compares everything but the data. Any suggestions from your
> experience?
FWIW, I think it's pretty common to use "schema" in an abstract way
to mean "the structure of your database", ie everything but the d
On Sun, May 28, 2017 at 9:51 AM, Adrian Klaver
wrote:
> On 05/28/2017 05:49 AM, Neil Anderson wrote:
>
>> Hi,
>>
>> I'm working on a tool that can compare the properties of Postgres
>> objects from different instances, finding the differences and
>> outputting the update SQL.
>>
>> It can compare
On 05/28/2017 05:49 AM, Neil Anderson wrote:
Hi,
I'm working on a tool that can compare the properties of Postgres
objects from different instances, finding the differences and
outputting the update SQL.
It can compare objects that are defined at the cluster, database or
schema level. As such I
Hi,
I'm working on a tool that can compare the properties of Postgres
objects from different instances, finding the differences and
outputting the update SQL.
It can compare objects that are defined at the cluster, database or
schema level. As such I'm finding it difficult to describe what the
to