BUG #6613: tablespace data ignored after reinstalling windows

From: ghircoiascamil(at)yahoo(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6613: tablespace data ignored after reinstalling windows
Date: 2012-04-25 19:34:11
Message-ID: E1SN7yd-0002f9-V3@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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
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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Ari Entlich 2012-04-25 20:25:11 Re: BUG #6612: Functions can be called inside CHECK statements
Previous Message Tom Lane 2012-04-25 17:54:16 Re: BUG #6602: concurrent psql session clobbers history