| From: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Ever increasing OIDs - gonna run out soon? |
| Date: | 2006-06-12 20:21:31 |
| Message-ID: | 448DCCCB.4080201@wardbrook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Slony does appear to use OIDs.
John
Jim C. Nasby wrote:
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-06-12 20:32:45 | Re: Ever increasing OIDs - gonna run out soon? |
| Previous Message | Alex Turner | 2006-06-12 19:26:56 | Re: Ever increasing OIDs - gonna run out soon? |