A very timely answer, and we'd debating moving to 9.2 at the same time but
decided on staying on the 8.4 line (latest patch level though). After we do
this we should be able to do a regular, normal pg_dump (not excluding anything)
to get from 8.4 -> 9.2 in a few weeks from now.
Thanks so much T
Scott Corscadden writes:
> ** MY QUESTION ** - Will pg_largeobject automatically choose new OIDs that
> don't conflict, if I've added lo's this way, by direct COPY?
In 8.4, yes. In later versions, you'd need to do something about
creating corresponding rows in pg_largeobject_metadata.
In gener
I'm pruning an 8.4 database that was using a *lot* of space in pg_largeobject
(400GB according to my size query). What I've done seems to work, but I don't
know if there's a time-bomb waiting for me, so I have to ask you who've
implemented this part. Steps:
1) On new.better.server.com:
