Fwd: postgresql9.4 aws - no pg_upgrade

Hi Team,

We tried in production, pg_upgrade works well. But running vacuumdb ,
resulted in huge spike in CPU, system halted. Is there a way to fasten or
parallel vacuum solution for faster recovery after pg_upgrade.

Our database size is around 500GB, contains multiple databases, huge
records. What is the minimum way to do a vacuuming after pg_upgrade? This
is for migration from 9.3 to 9.4.

Thanks
Balaji Jayaraman

On Tue, Oct 17, 2017 at 2:13 PM, bala jayaram <balajayaram22(at)gmail(dot)com>
wrote:

> Thanks, i resolved by following other forums. seems we should not have
> tablespace inside data ( even symlink) as well. Once i moved the tables
> space to other location & updated the symlinks, pg_upgrade completed very
> fast within 4 mins. Thanks a lot for your support.
>
> -Thanks
> Balaji Jayaraman
>
> On Mon, Oct 16, 2017 at 4:54 PM, bala jayaram <balajayaram22(at)gmail(dot)com>
> wrote:
>
>> I created CentoS, moved the data of 9.3 , completed the setup. later
>> installed 9.4 , I could see pg_upgrade in that.
>> We have two tables space, which are symlink to directory just before data
>> directory
>> #ls -lrt
>> /data/pgsql93/<tb1>
>> /data/pgsql93/<tb2>
>> /data/pgsql93/data/ --> here is the 9.3 pgdata presents
>>
>> Inside /data/pgsql93/data/pg_tblspc/ , two folders are symlined into
>> above folders(tb1 & tb2)
>>
>> While doing pg_upgrade with link option, Do i need to copy the table
>> space (tb1 & tb2) to the new pgsql94 directories? or Create Folders
>> structure similar to pgsql93 tablespace?
>>
>> i got an error while doing pg_upgrade with link option
>> psql:pg_upgrade_dump_globals.sql:91: ERROR: directory
>> "/data/pgsql93/<tb1>/PG_9.4_201409291" already in use as a tablespace
>>
>> How to resolve this?
>>
>> Thanks
>> Balaji Jayaraman
>>
>>
>>
>>
>> On Mon, Oct 16, 2017 at 11:42 AM, Joshua D. Drake <jd(at)commandprompt(dot)com>
>> wrote:
>>
>>> On 10/16/2017 06:13 AM, bala jayaram wrote:
>>>
>>>> I have installed postgres-contrib package as well. But pg_upgrade is
>>>> not available. From this forum, https://forums.aws.amazon.com/
>>>> thread.jspa?threadID=227761
>>>> amazon didnt provide pg_upgrade, thats the concern. Am going to try out
>>>> with CentOS with existing DB Data, and use RDS import using migration
>>>> service.
>>>>
>>>>
>>> That was going to be my next suggestion.
>>>
>>> Good Luck!
>>>
>>>
>>> JD
>>> --
>>> Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
>>>
>>> PostgreSQL Centered full stack support, consulting and development.
>>> Advocate: @amplifypostgres || Learn: https://pgconf.us
>>> ***** Unless otherwise stated, opinions are my own. *****
>>>
>>
>>
>