Search Postgresql Archives

Re: pg_upgrade & tablespaces

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/31/2013 01:51 PM, Joseph Kregloh wrote:
        So you have not upgraded the tablespaces. What is important to
        remember is Postgres uses numbers to keep track of relations.
        Part of the upgrade process involves changing the numbers that
        point at relations. By manually dropping a 9.0 tablespace into a
        9.3 data directory you have broken that system. You need to let
          pg_upgrade do the translation. See my previous message below
        for a possible solution:



Sorry, I may not have been to clear on my explenation, pg_upgrade
creates the 9.3 data directories inside the tablespace folders and those
are the ones I moved. So pg_upgrade finishes it's job.

Can we see a listing of the tablespace and pg_tblspc?

--
Adrian Klaver
adrian.klaver@xxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux