The following bug has been logged on the website:
Bug reference: 6613
Logged by: Camil Ghircoias
Email address: ghircoiascamil@yahoo.com
PostgreSQL version: 9.1.3
Operating system: Windows 7
Description:=20=20=20=20=20=20=20=20
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=20
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.