| From: | Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres architecture for multiple instances |
| Date: | 2015-02-22 07:59:36 |
| Message-ID: | 1424591976.2964.8.camel@eppesuigoccas.homedns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Il giorno sab, 21/02/2015 alle 16.01 -0600, Samuel Smith ha scritto:
> Howdy,
> I am looking for advice on migrating to postgres from another database
> system.
[...]
People already wrote you some comments, here are two more.
DB2 instances run as different OS users, so if you need the same
approach for security reasons, you will need to create different
postgresql clusters.
Another important fact is about large objects, if you happen to use
them: their OID is not just unique to the database, but to the whole
cluster. This means that when you move a database in a cluster from a
production system to a database on a test cluster, you may get errors
when same OID already exists in target cluster (even if it is used in a
different database).
Bye,
Giuseppe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Mamin | 2015-02-22 09:44:17 | Re: Postgres architecture for multiple instances |
| Previous Message | David G Johnston | 2015-02-22 04:26:31 | Re: Array string casts with SELECT but not SELECT DISTINCT |