Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

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.

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group