For private databases, I'd like to create a tablespace in my encrypted
/home directory. However, /home is only mounted on demand (through pam-
mount), when I log-in, in particular, it is mounted after the PostgreSQL
server has been started. Is this possible within the specification of
PostgreSQL?

Michael

--
Michael Schuerig
mailto:michael (AT) schuerig (DOT) de
http://www.schuerig.de/michael/

On Sat, 08 May 2010 20:39:25 +0200, Michael Schuerig wrote:

No, it is not possible. Postgres, at least until the version 8.4, does
not recognize on-line and offline databases or tablespaces. You also
cannot open database in read-only mode. In the version 9.0, some of these
restrictions will probably be lifted, but not in the current stable
versions.




--
http://mgogala.byethost5.com

On 2010-05-08, Michael Schuerig <michael (AT) schuerig (DOT) de> wrote:
no, to get that to work you'd have to setup your own postgresql server
process, start it after you log in, and stop it before unplugging the
media.

It should be possible to run postmaster in your name on a different
socket to the main server without needing root


--- news://freenews.netfront.net/ - complaints: news (AT) netfront (DOT) net ---

Jasen Betts wrote:

That's exactly what I want to avoid. On my Linux machine, I'm using KDE
which, out of the box, runs its own MySQL server process for storing
filesystem metadata, such as tags and ratings. Since the most recent
upgrade, it is also possible to use databases managed by existing MySQL
and PostgreSQL instances, i.e. without running an additional server.

In my case, as I keep /home on my notebook encrypted, I consider it
mandatory to encrypt the metadata too. Also, I don't see why I ought to
run more server processes than are really necessary. And, of course, I
prefer PostgreSQL over the alternative. Thus, it would have been nice if
PostgreSQL would work with a "detachable" tablespace.

Michael

--
Michael Schuerig
mailto:michael (AT) schuerig (DOT) de
http://www.schuerig.de/michael/

On Sun, 09 May 2010 13:08:37 +0200, Michael Schuerig wrote:

Yes, it would be very nice to have detachable tablespace or read-only
database.



--
http://mgogala.byethost5.com