Tablespaces

Hi list,

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.....​

​Thanks in advance, ​

​Ills​