Tablespaces
| От | Illya |
|---|---|
| Тема | Tablespaces |
| Дата | |
| Msg-id | CA+MS+4Rxeaph4vOvOUkuWdxrwuoFvWKh+_5t5iO8gQ42wAJenQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Tablespaces
|
| Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: