The following bug has been logged on the website: Bug reference: 6613 Logged by: Camil Ghircoias Email address: ghircoiasca...@yahoo.com PostgreSQL version: 9.1.3 Operating system: Windows 7 Description:
Had this scenario: OS:Windows 7 Install postgresql 9.1 in Program Files Postgresql data directory was set in d:\mydata\postgresql. Created table space called data in d:\mydata\data. Had 2 databases created in the data tablespace. Reinstalled windows (formatted disk c). Reinstalled postgresql (the same kit) with the data directory set to the old one d:\mydata\postgresql Open pgadmin, connected succesfully to the server, the 2 databases were there but when trying to connect get a message that the folder \pg_tblspc\an oid\pg version..\the database oid was not found. Succeded to make it to work by copying the oid databases folder from d:\mydata\data into d:\mydata\postgresql Even pgadmin shows the tablespace data in d:\mydata\data and the 2 databases had the tablespace data not pg_default postgresql it uses the pg_default tablespace for storing the data, the d:\mydata\data folder I could delete it's files without any problems and postgresql worked. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs