Re: Tablespaces

Illya wrote:
> 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​

As I understand, the location is stored in symlinks in your data
directory only, so to fix it it should work to stop the server, change
the symlink to point to the right drive, then restart.

Probably it was Windows itself that updated the symlink when it saw that
the destination drive E: no longer existed.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services