Fwd: [ADMIN] postgresql9.4 aws - no pg_upgrade

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@gmail.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@commandprompt.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.   *****