| From: | Ola Sandbu <ola(dot)sandbu(at)usit(dot)uio(dot)no> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Bloated pg_shdepend_depender_index |
| Date: | 2006-03-29 12:38:27 |
| Message-ID: | 442A7FC3.4060600@usit.uio.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Andy Shellam wrote:
> This is true, but you could run the new version on the same server/different
> port to the current version, and do a simultaneous dump/restore without
> having to use extra disk space, or taking your production database offline -
> then you can schedule a time to kill the old one, re-assign the port on the
> new one and bring it up - would take about 30 seconds, and this could be
> done at a time when traffic was at its lowest.
>
Hmmm - Interesting solution!
Does you know of anybody that have tried an upgrade migration like this,
and experience with very large databases?
--
-------------------------------------
Ola Sandbu tel: (+47)22840197
USIT/SAPP-DBA mob: (+47)91594704
mailto:Ola(dot)Sandbu(at)usit(dot)uio(dot)no
-------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2006-03-29 12:45:59 | Re: FW: Setting up of PITR system. |
| Previous Message | Andy Shellam | 2006-03-29 12:19:02 | Re: FW: Setting up of PITR system. |