Re: pg_upgrade & tablespaces

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Thu, Dec 19, 2013 at 12:49 PM, Joseph Kregloh <jkregloh@xxxxxxxxxxxxxx> wrote:

[pgsql@postgres-93-upgrade ~]$ ls -l /home/jkregloh/pg_data/data/pg_tblspc/

lrwxr-xr-x  1 pgsql  pgsql        41 Dec 19 19:53 11047389 -> /home/jkregloh/pg_data/data/stats_dbspace

lrwxr-xr-x  1 pgsql  pgsql        44 Dec 19 19:53 11047390 -> /home/jkregloh/pg_data/data/stats_indexspace

lrwxr-xr-x  1 pgsql  pgsql        49 Dec 19 19:53 11047391 -> /home/jkregloh/pg_data/data/stats_staging_dbspace

lrwxr-xr-x  1 pgsql  pgsql        52 Dec 19 19:53 11047392 -> /home/jkregloh/pg_data/data/stats_staging_indexspace

Can you show the same thing on the 9.3 data directory, after the failed upgrade?

It seems to me that you guys have made a mess out of your disk layout, and pg_upgrade is struggling to preserve the mess, but failing.  What is the point of having 80 tablespaces, especially if they just point back to the same place?

Cheers,

Jeff