Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrade postgresql from 9.1 to 9.6 - Mailing list pgsql-admin

From Sohel Tamboli
Subject Re: Upgrade postgresql from 9.1 to 9.6
Date
Msg-id CAAbZosB743pMobmYN3hrd1tpVOfdak-BHG9aZ2LyyMh9Tvmu_g@mail.gmail.com
Whole thread Raw
In response to Re: Upgrade postgresql from 9.1 to 9.6  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Upgrade postgresql from 9.1 to 9.6  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view
Hi Ron, 

Thanks!! 
I tried to grep all the process owned by postgres as well, but got same results.  No other process are active other than two threads of pg_upgrade. 

Thanks, 
Sohel

On 23-Jul-2018 10:53 pm, "Ron" <ronljohnsonjr@gmail.com> wrote:
I'd grep for all processes owned by postgres, since the pg_upgrade processes probably spawn children.


On 07/23/2018 12:14 PM, Sohel Tamboli wrote:
Hi,

I am trying to upgrade my postgresql database from version 9.1 to 9.6 using pg_upgrade utility.
I have started this activity with 6 threads and running with no issues but I can see only 2 active threads of pg_upgrade  when checked on OS using "ps -ef| grep pg_upgrade" which might slow down my upgrade process.
Is there any limit of adding jobs in "-j" parameter in pg_upgrade utility?
Or is there any settings that I need to configure in postgresql.conf file?

Below are the configuration of my server:
OS : Amazon Linux
RAM: 64GB
CPU: 16
DB size : 5 TB
Upgrade utility : pg_upgrade
Jobs: 6
Issue : only 2 threads of pg_upgrade are active

Appreciate your help!!

Thanks,
Sohel

--
Angular momentum makes the world go 'round.


pgsql-admin by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_authid has duplicated rows
Next
From: Mariel Cherkassky
Date:
Subject: Re: pg_authid has duplicated rows