Re: Upgrading from PostgreSQL 9.3 to 11.6

On 2019-12-20 09:02, Justin wrote:
> Hi Tony
>
> Can you describe the database in greater detail? how many tables,
> type of data, how big is the down time window?
>
> So this will be on new server hardware, and new DB install, what OS?
> and extensions being used, has there been any testing
>
> with apps on latter versions of PostgreSQL???
>
> On Fri, Dec 20, 2019 at 8:58 AM <tony(at)exquisiteimages(dot)com> wrote:
>
>> I have a PostgreSQL 9.3 installation that I finally have time to
>> migrate
>> to a currently supported version. The server that the installation
>> is
>> installed on is also at its end of service.
>>
>> Can anyone help me with completing this conversion as securely and
>> efficiently as possible with the least amount of down time? Also,
>> once
>> it has been converted over, is there any best practice for ensuring
>> that
>> there has been no corruption?
>>
>> The database is 600GB in size. We do not have any custom types being
>>
>> used.
>>
>> Thanks for any direction.

Thanks for the reply!

New Server OS: Ubuntu Server 18.04.3 LTS

Schemas: 9,000

Total Tables: 900,000

Data is mostly transactional detail (90%), some summary tables (8%), and
basic client demographic data (2%)

Everyone wants the down time to be zero, but I don't think that is
really possible. I am thinking about 4 hours on a weekend night is going
to be what I can get approved.

My plan was to go through the conversion process once to see if
everything goes well. I would then use the new server as a test server
and run our full battery of applications against it to make sure that we
obtain the same results as from a back copy of the live database.