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

Re: Portable database ... ?

From: Bob McConnell <rmcconne(at)lightlink(dot)com>
To: "Florian v(dot) Savigny" <lorian(at)fsavigny(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Portable database ... ?
Date: 2009-02-20 21:43:35
Message-ID: 499F2407.2050202@lightlink.com (view raw or flat)
Thread:
Lists: pgsql-novice
Florian v. Savigny wrote:
> Dear community,
> 
> I'm not sure whether this is the appropriate forum (maybe it's
> actually better asked on the developers' list), but as my impression
> grows my question might be naive, I thought I should probably duly
> start as a novice:
> 
> Is there any way to have the Linux and the Windows versions of
> PostgreSQL use the same database? (On a double-boot machine.)
> 
> When trying this, I ran into trouble as soon as I tried to initiate a
> database on a VFAT partition while running Linux. That seemed to fail
> because VFAT does not support (sym)links:
> 
>    PANIC: could not link file "<root>/pg_xlog/xlogtemp.3846" to
>    "<root>/pg_xlog/000000010000000000000000" (initialization of log
>    file 0, segment 0): the operation is not permitted
> 
> ("<root>" is the directory I specified to initdb using the -D option).
> 
> What made me a little curious about this is that when I initiate a
> database on an ext3 partition, which of course succeeds, it definitely
> does not seem to contain any hard links or symlinks, just regular
> files (and none of the regular files has a link count >1).
> 
> Of course a host of other issues could prevent such a "dual-OS", or
> "portable" database. I actually would just like to ask whether the
> route is worth pursuing at all ...

I would suspect permission issues before the symlink problems. I don't 
believe VFAT supports any of the security models that PG can use.

Bob McConnell
N2SPP

In response to

pgsql-novice by date

Next:From: Frank BaxDate: 2009-02-20 22:34:19
Subject: Re: Portable database ... ?
Previous:From: Florian v. SavignyDate: 2009-02-20 17:44:00
Subject: Re: Portable database ... ?

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