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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
