>> 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.kla...@aklaver.com -- Neil Anderson n...@postgrescompare.com https://www.postgrescompare.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
