I am using a workstation that has 3 different hard drives. Some time ago I got a large database to reverse engineer that would not fit in the system drive. Therefore I created a new table-space in one of the the other hard drives, that at the time was mounted on the
Everything was working fine, until today at startup the system decided to mount the drive on the
/media/Work folder. Naturally, Postgres can no longer access the databases in that table-space.
How can I change the location of a table-space in Postgres? I am aware of the
pg_tablespace_location function, but not of somthing to modify it.