Re: Postgresql 9.4 pg_upgrade issues

From: Yogi Barot <YBarot(at)symcor(dot)com>
To: 'Bruce Momjian' <bruce(at)momjian(dot)us>
Cc: 'Albe Laurenz' <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgresql 9.4 pg_upgrade issues
Date: 2015-11-24 21:45:16
Message-ID: 2589bd2f0d7e44a1902d20e388351bff@MX002.symprod.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 +

Attachment Content-Type Size
unknown_filename text/plain 1.0 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message 'Bruce Momjian' 2015-11-24 21:46:08 Re: Postgresql 9.4 pg_upgrade issues
Previous Message Bruce Momjian 2015-11-24 21:41:14 Re: Postgresql 9.4 pg_upgrade issues