Hi postgresql 9.1 on Ubuntu 10.04 My database was spread over multiple tablespaces, spread over mutliple discs. Now i lost one of the discs = one tablespace. The database does start, but when I try to access the database, it complains psql: FATAL: could not open file ... I tried to point the symlink in pg_tblspc/ to a new directory, but it is looking for files there now... All important information is in the other tablespaces. I would be totally happy to just loose all relations in that lost tablespace. It's just indexes. Is there any way to tell PG to drop/ignore that tablespace and access the database? Many thanks in advance Steve -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
