Re: 9.2 to 9.5 pg_upgrade losing data

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Pete Fuller <pfuller(at)3sitracking(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.2 to 9.5 pg_upgrade losing data
Date: 2016-08-15 17:54:05
Message-ID: 372a107b-d415-b6b0-8b07-a901dde4c400@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/15/2016 08:04 AM, Pete Fuller wrote:
> We have not found any obvious differences, other than the size of the
> databases (~ 100 gig on the testing site vs 400 Gig in production). In
> fact, the upgrade path seems to work with our production db when testing
> on our offsite replica that lives in our backup datacenter, near
> identical hardware and setup with same install scripts.
>

Idea that popped into head, how do you get the data to the dbs in the
offsite replica versus how do you get the data to the live replica?

Also are all the machines running the same chip architecture?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pete Fuller 2016-08-15 18:52:48 Re: 9.2 to 9.5 pg_upgrade losing data
Previous Message rob stone 2016-08-15 17:35:25 Re: 9.2 to 9.5 pg_upgrade losing data