| From: | Jens Wilke <jens(dot)wilke(at)affinitas(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: upgrade postgres 8.1.21 to version 8.3.6 |
| Date: | 2010-07-13 10:58:01 |
| Message-ID: | 201007131258.01800.jens.wilke@affinitas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Am Dienstag 13 Juli 2010 11:30:20 schrieb Silvio Brandani:
> We need to upgrade the postgres running on our production system under
> Red Hat Enterprise Linux Server release 5.1 from version 8.1.21 to
> version 8.3.6.
Have a look here:
http://wiki.postgresql.org/wiki/RPM_Installation#How_do_I_perform_a_major_upgrade.3F
You should test the restore of your dump on another port or maschine first.
this might be of interest for you as well:
http://blog.endpoint.com/2010/01/postgres-upgrades-ten-problems-and.html
> Which is the best practice to execute such upgrade with possible
> rollback operation
Do a filesystem backup.
You should test the restore of your dump on another port or maschine first.
> to gain in 3/4 hour this job ??
That depends on your hardware.
Jens
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Plugge, Joe R. | 2010-07-13 15:40:08 | Partitioned Tables |
| Previous Message | Devrim GÜNDÜZ | 2010-07-13 10:04:06 | Re: postgresql failover |