| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Improving pg_dump performance |
| Date: | 2018-07-23 18:41:22 |
| Message-ID: | 20180723184122.zvkqklm6swh6igmt@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2018-07-23 09:17:41 -0500, Ron wrote:
> On 07/23/2018 09:11 AM, Andres Freund wrote:
> > Hi,
> >
> > On 2018-07-23 02:23:45 -0500, Ron wrote:
> > > We've got an old (v8.4.17, thus no parallel backups) 2.9TB database that
> > > needs to be migrated to a new data center and then restored to v9.6.9.
> > Have you considered using pg_upgrade instead?
>
> Yes, but:
> 1. can't find 9.6 packages on the RHEL 5.10 server.
If necessary you could just build it yourself.
> 2. The window is only 8 hours, and the data also has to be moved to a new DC
> in that window.
You could just use physical drives ;)
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-07-23 19:04:22 | Re: Connections on cluster not being logged |
| Previous Message | Nicola Contu | 2018-07-23 16:41:59 | Waiting connections postgres 10 |