[rt-users] Upgrading the database (postgres)

[Vivek Khera]

>>>>> "MB" == Michael Bielicki <Michael.BLK at 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?