It's come to our attention that in 14-16 days our OID's will wrap around and
we need some advice. We're running 7.3.5 in our current production and plan
to eventually move to 7.4.6 which we have in testing. Production consists
of one database cluster with 26 databases. All tables are created with the
default, ie. WITH OIDS. We have many tables that have an OID type column
which is used for storing files. We intent to migrate away from that but
that too is in testing only.
We have thought about doing a dump and restoring to a new database cluster
but at the current rate we'll be in the same boat in roughly 120 days. We
have also thought of doing a dump and to 7.4.6 and performing an "ALTER
TABLE SET WITHOUT OIDS" on every table.
Anything else we can do? Have I read too much into the OID wrap-around
Product Development Manager
Technology. Integrity. Focus.
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-02-18 14:48:46|
|Subject: Re: OID assistance |
|Previous:||From: Michael Fuhr||Date: 2005-02-18 01:51:29|
|Subject: Re: how to view running sessions ?|