Re: Conservation of OIDs
Berend Tober <btober@seaworthysys.com>
From: <btober@seaworthysys.com>
To: <nandrews@investsystems.co.uk>
Cc: <btober@seaworthysys.com>, <mkoi-pg@aon.at>,
<pgsql-general@postgresql.org>
Date: 2003-11-16T01:50:02Z
Lists: pgsql-general
> Whoa! You mean these aren't already separate database clusters or even > separate systems? I am very shocked, you can't do a proper Dev --> QAT > --> Prod environment if all three systems are run by the same > postmaster, or on the same host imo. I can see having separate clusters would save me the unnecessary expenditure of OID',s, and I can see access to the production data being restricted (from developers?) in most cases as a good thing, but for this environment the set of end-users and developers is actually quite small, they are in close proximity and have ready communication, and so I don't see why it would be a problem to have the same postmaster running all three databases for this case. I would be interested in hearing more detail as to why it is a bad idea in general. ~Berend Tober