I have a large amount of data in a number of databases on a separate internal drive, under the tablespace e_drive which normally sits in location E:\postgis. This setup has been been working happily for years. Yesterday I became unable to connect to any of the databases in the e_drive tablespace. I connected to the cluster and ran \db and lo the location is now changed to C for some unknown reason (I haven't upgraded or anything like that).
Name | Owner | Location
------------+----------+------------
e_drive | theowner | C:\postgis
I realise that I can't use ALTER TABLESPACE for this, so can I delete the tablespace e_drive and recreate it with the correct location and everything will be fine?
Or am I going to have to use pg_dumpall and hope I can dump the data out.....