[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 lrwxr-xr-x 1 pgsql pgsql 44 Dec 19 19:53 22319 -> /home/jkregloh/pg_data/data/datapipe_dbspace lrwxr-xr-x 1 pgsql pgsql 47 Dec 19 19:53 22320 -> /home/jkregloh/pg_data/data/datapipe_indexspace lrwxr-xr-x 1 pgsql pgsql 46 Dec 19 19:53 22321 -> /home/jkregloh/pg_data/data/datapipe_zlogspace lrwxr-xr-x 1 pgsql pgsql 44 Dec 19 19:53 22322 -> /home/jkregloh/pg_data/data/p3_basic_dbspace lrwxr-xr-x 1 pgsql pgsql 47 Dec 19 19:53 22323 -> /home/jkregloh/pg_data/data/p3_basic_indexspace lrwxr-xr-x 1 pgsql pgsql 38 Dec 19 19:53 22324 -> /home/jkregloh/pg_data/data/p3_dbspace lrwxr-xr-x 1 pgsql pgsql 41 Dec 19 19:53 22325 -> /home/jkregloh/pg_data/data/p3_indexspace lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 22326 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_001 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 22327 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_001 lrwxr-xr-x 1 pgsql pgsql 43 Dec 19 19:53 22328 -> /home/jkregloh/pg_data/data/p3_zlog_dbspace lrwxr-xr-x 1 pgsql pgsql 46 Dec 19 19:53 22329 -> /home/jkregloh/pg_data/data/p3_zlog_indexspace lrwxr-xr-x 1 pgsql pgsql 41 Dec 19 19:53 22330 -> /home/jkregloh/pg_data/data/sling_dbspace lrwxr-xr-x 1 pgsql pgsql 44 Dec 19 19:53 22331 -> /home/jkregloh/pg_data/data/sling_indexspace lrwxr-xr-x 1 pgsql pgsql 51 Dec 19 19:53 2260532 -> /home/jkregloh/pg_data/data/p3_olap_staging_dbspace lrwxr-xr-x 1 pgsql pgsql 54 Dec 19 19:53 2260533 -> /home/jkregloh/pg_data/data/p3_olap_staging_indexspace lrwxr-xr-x 1 pgsql pgsql 52 Dec 19 19:53 2283998 -> /home/jkregloh/pg_data/data/p3_olap_datamart_dbspace lrwxr-xr-x 1 pgsql pgsql 55 Dec 19 19:53 2283999 -> /home/jkregloh/pg_data/data/p3_olap_datamart_indexspace lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327012 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_002 lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327013 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_003 lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327014 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_004 lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327015 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_005 lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327016 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_006 lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327017 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_007 lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327018 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_008 lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327019 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_009 lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 2327020 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_data_010 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327021 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_002 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327022 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_003 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327023 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_004 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327024 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_005 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327025 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_006 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327026 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_007 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327027 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_008 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327028 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_009 lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 2327029 -> /home/jkregloh/pg_data/data/p3_dd_tablespaces/list_index_010 lrwxr-xr-x 1 pgsql pgsql 42 Dec 19 19:53 2752416 -> /home/jkregloh/pg_data/data/drupal_dbspace lrwxr-xr-x 1 pgsql pgsql 45 Dec 19 19:53 2796385 -> /home/jkregloh/pg_data/data/drupal_indexspace lrwxr-xr-x 1 pgsql pgsql 55 Dec 19 19:53 5819045 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/january lrwxr-xr-x 1 pgsql pgsql 56 Dec 19 19:53 5819046 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/february lrwxr-xr-x 1 pgsql pgsql 53 Dec 19 19:53 5819047 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/march lrwxr-xr-x 1 pgsql pgsql 53 Dec 19 19:53 5819048 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/april lrwxr-xr-x 1 pgsql pgsql 51 Dec 19 19:53 5819049 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/may lrwxr-xr-x 1 pgsql pgsql 52 Dec 19 19:53 5819050 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/june lrwxr-xr-x 1 pgsql pgsql 52 Dec 19 19:53 5819051 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/july lrwxr-xr-x 1 pgsql pgsql 54 Dec 19 19:53 5819052 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/august lrwxr-xr-x 1 pgsql pgsql 57 Dec 19 19:53 5819053 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/september lrwxr-xr-x 1 pgsql pgsql 55 Dec 19 19:53 5819054 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/october lrwxr-xr-x 1 pgsql pgsql 56 Dec 19 19:53 5819055 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/november lrwxr-xr-x 1 pgsql pgsql 56 Dec 19 19:53 5819056 -> /home/jkregloh/pg_data/data/p3_ord_list_dbspace/december lrwxr-xr-x 1 pgsql pgsql 58 Dec 19 19:53 5819057 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/january lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 5819058 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/february lrwxr-xr-x 1 pgsql pgsql 56 Dec 19 19:53 5819059 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/march lrwxr-xr-x 1 pgsql pgsql 56 Dec 19 19:53 5819060 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/april lrwxr-xr-x 1 pgsql pgsql 54 Dec 19 19:53 5819061 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/may lrwxr-xr-x 1 pgsql pgsql 55 Dec 19 19:53 5819063 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/june lrwxr-xr-x 1 pgsql pgsql 55 Dec 19 19:53 5819064 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/july lrwxr-xr-x 1 pgsql pgsql 57 Dec 19 19:53 5819065 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/august lrwxr-xr-x 1 pgsql pgsql 60 Dec 19 19:53 5819066 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/september lrwxr-xr-x 1 pgsql pgsql 58 Dec 19 19:53 5819067 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/october lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 5819068 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/november lrwxr-xr-x 1 pgsql pgsql 59 Dec 19 19:53 5819070 -> /home/jkregloh/pg_data/data/p3_ord_list_indexspace/december lrwxr-xr-x 1 pgsql pgsql 43 Dec 19 19:53 764614 -> /home/jkregloh/pg_data/data/clients_dbspace lrwxr-xr-x 1 pgsql pgsql 46 Dec 19 19:53 764617 -> /home/jkregloh/pg_data/data/clients_indexspace lrwxr-xr-x 1 pgsql pgsql 45 Dec 19 19:53 764620 -> /home/jkregloh/pg_data/data/clients_zlogspace lrwxr-xr-x 1 pgsql pgsql 47 Dec 19 19:53 9296296 -> /home/jkregloh/pg_data/data/clients_report_data lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669440 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2006 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669441 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2007 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669442 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2008 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669443 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2009 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669444 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2010 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669445 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2011 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669446 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2012 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669447 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2013 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669448 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2014 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669449 -> /home/jkregloh/pg_data/data_archive/dd_archive/tablespaces/2015 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669450 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2006 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669451 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2007 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669452 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2008 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669453 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2009 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669454 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2010 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669455 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2011 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669456 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2012 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669457 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2013 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669458 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2014 lrwxr-xr-x 1 pgsql pgsql 63 Dec 19 19:53 9669459 -> /home/jkregloh/pg_data/data_archive/dd_archive/indexspaces/2015
-Joseph On Thu, Dec 19, 2013 at 3:46 PM, Sergey Konoplev <gray...@gmail.com> wrote: > On Thu, Dec 19, 2013 at 12:27 PM, Joseph Kregloh > <jkreg...@sproutloud.com> wrote: > > So what I get from this is that it does create the correct 9.3 files in > the > > new location, however it cannot copy the relation over because the old > data > > is in the /home/jkregloh/pg_data/data/drupal_dbspace/ not in > > /usr/local/pgsql/data/drupal_dbspace/ as the pg_upgrade query tries to > do. > > Can you show what ls -l /home/jkregloh/pg_data/data/pg_tblspc/ prints, > please? > > -- > Kind regards, > Sergey Konoplev > PostgreSQL Consultant and DBA > > http://www.linkedin.com/in/grayhemp > +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 > gray...@gmail.com >
