BUG #3232: Regression: pgsql server startup problem with encrypted partitions - Mailing list pgsql-bugs

From Carsten
Subject BUG #3232: Regression: pgsql server startup problem with encrypted partitions
Date
Msg-id 200704162356.l3GNuThI019470@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3232: Regression: pgsql server startup problem with encrypted partitions
Re: BUG #3232: Regression: pgsql server startup problem with encrypted partitions
List pgsql-bugs
The following bug has been logged online:

Bug reference:      3232
Logged by:          Carsten
Email address:      fcarsten@tpg.com.au
PostgreSQL version: 8.2.3
Operating system:   Windows XP SP 2
Description:        Regression: pgsql server startup problem with encrypted
partitions
Details:

I am running the following scenario:

* Windows XP SP 2
* Postgres 8.2.3 installed on a normal Windows partition
* One highly sensitive database on a seperate table space which is located
on a TureCrypt partition
* The TrueCrypt partition only can be mounted after I log into the machine
(as I have to enter the password)

In the version of PostgreSQL which I was using previously (don't remember
version number) this scenario worked fine. As long as I didn't try to access
a database on the encrypted partition before mounting it the pgsql server
was happy.

In current version this no longer works. I have to manually restart the
pgsql server after mounting the encyprted partition to access the database
on it.

Were there any changes which made the pgsql server stricter in requiring
that all table-spaces exist on start-up? If yes, any chance of reversing
this to support databases on encrypted partitions or removable devices?

pgsql-bugs by date:

Previous
From: "Dmitry Belyavsky"
Date:
Subject: BUG #3233: Trigger checks failed on concurrent transactions
Next
From: "Amorn Buchheit"
Date:
Subject: Submit bug report via bug web form - couldn't find the thread