Re: Upgrade postgresql from 9.1 to 9.6

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(at)gmail(dot)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.