The following bug has been logged on the website:
Bug reference: 6613
Logged by: Camil Ghircoias
Email address: ghircoiascamil(at)yahoo(dot)com
PostgreSQL version: 9.1.3
Operating system: Windows 7
Had this scenario:
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
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.
pgsql-bugs by date
|Next:||From: Ari Entlich||Date: 2012-04-25 20:25:11|
|Subject: Re: BUG #6612: Functions can be called inside CHECK statements|
|Previous:||From: Tom Lane||Date: 2012-04-25 17:54:16|
|Subject: Re: BUG #6602: concurrent psql session clobbers history |