Hi there,
I want to upgrade to postgresql 7.2 since I tested it and it has a
rather significant speed increase through a much much better optimizer
and some other tweaks. Now, can I basically simply dump the rt db and
load it agin or is their some oid stuff that will destroy my rt system ?
I have aoround 30.000 entries by now and a speed improvement would get
me probably a bottle of champaign fr5om the support guys 
regards
Michael Bielicki
signature.asc (232 Bytes)
“MB” == Michael Bielicki Michael.BLK@Freezone.co.uk writes:
MB> I want to upgrade to postgresql 7.2 since I tested it and it has a
MB> rather significant speed increase through a much much better optimizer
MB> and some other tweaks. Now, can I basically simply dump the rt db and
MB> load it agin or is their some oid stuff that will destroy my rt system ?
I’m about to embark on the same. I’ve dumped and restored rt within
Postgres 7.1.3 with no problems. I don’t believe there are any
incompatibilities between postgres versions as far as the SQL goes, so
it should work. Please let us know if there were problems.
You will test out your process on a development server first, right?