Re: Postgresql 9.5 error

Yogi Barot schrieb am 18.02.2016 um 15:14:
> I have migrated data from postgresql 9.0 to 9.5, When I run following command, it does not
> show tablespace location and fails with bellow error. Can someone provide fix in the next release?
>
>
> We are planning to put release in production from March 15, hopefully get fix before this date.
>
> postgres=# select * from pg_tablespace; -- Spclocation column is missing in pg_tablespace.
>
> spcname | spcowner | spcacl | spcoptions
>
> -----------------+----------+--------+------------
> pg_default | 10 | |
> pg_global | 10 | |
> foa_table_space | 16384 | |
>
> (3 rows)
>
> *postgres=# \db**
> *ERROR: column "spclocation" does not exist*
> *LINE 3: spclocation AS "Location"*

From the 9.2 release notes:

E.16.2. Migration to Version 9.2

Remove the spclocation field from pg_tablespace (Magnus Hagander)

This field was duplicative of the symbolic links that actually define tablespace locations, and thus risked errors
of omission when moving a tablespace. This change allows tablespace directories to be moved while the server is
down, by manually adjusting the symbolic links.

To replace this field, we have added pg_tablespace_location() to allow querying of the symbolic links.