| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Ever increasing OIDs - gonna run out soon? |
| Date: | 2006-06-12 16:47:04 |
| Message-ID: | 20060612164704.GY34196@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jun 12, 2006 at 05:02:09PM +0100, John Sidney-Woollett wrote:
> Jim C. Nasby wrote:
> > Except IIRC the OP is running 7.4 which doesn't have checks in DDL
> > code to deal with OID collisions. :(
>
> This is not good news! :(
>
> What about other long runing 7.4.x DBs? Do you really have to dump, init
> and restore every once in a while?
>
> Also, do you know what is actually using the OIDs - transactions?
Since you're running Slony, I suspect it's using them somehow. Or maybe
it doesn't create it's tables WITHOUT OIDs. Also note that any time you
create an object you burn through an OID.
Probably your best bet is to just upgrade to 8.1, which will gracefully
handle OID collisions.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian Weimer | 2006-06-12 17:35:28 | Re: Disk corruption detection |
| Previous Message | Martijn van Oosterhout | 2006-06-12 16:10:55 | Re: Ever increasing OIDs - gonna run out soon? |