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