Re: Postgresql 9.4 pg_upgrade issues

Thanks a lot for quick reply.

In this case, If I move table space out of old data directory using symlink, then can I remove old data directory?

-----Original Message-----
From: Bruce Momjian [mailto:bruce(at)momjian(dot)us]
Sent: Tuesday, November 24, 2015 4:41 PM
To: Yogi Barot
Cc: 'Albe Laurenz'; 'pgsql-admin(at)postgresql(dot)org'
Subject: Re: [ADMIN] Postgresql 9.4 pg_upgrade issues

On Tue, Nov 24, 2015 at 08:32:18PM +0000, Yogi Barot wrote:
> Hi,
>
> I was able to manage upgrade testing with cluster which does not have plsh for now.
>
> But I have another problem. All my data TB is in the tablespace in PGData directory, I did the upgrade using link method, now I got this warning.
>
> Upgrade Complete
> ----------------
> Optimizer statistics are not transferred by pg_upgrade so, once you
> start the new server, consider running:
> analyze_new_cluster.sh
>
> Could not create a script to delete the old cluster's data files
> because user-defined tablespaces exist in the old cluster directory.
> The old cluster's contents must be deleted manually.
>
> 1) Does This means , I can't delete old cluster data directory? Or I can delete it manually?

If you delete the old data directory, you will delete the old _and_ _new_ cluster tablespaces.

> 2) Deleting old data directory will effect any functionality of postgresql new cluster?

Yep, you can bet on that. :-)

> 3) Also Need some clarification on link mode, what if I upgrade from 9.5. to future release using pg_upgarde link mode will still work on same data directory?

Yes, but I suggest you shut down your server and move those tablespaces out of the data directory, update the pg_tblspc symlinks, and then restart the server.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +