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

win32 tablespace handing

From: Reini Urban <rurban(at)x-ray(dot)at>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: win32 tablespace handing
Date: 2004-10-05 17:45:50
Message-ID: 4162DDCE.2060400@x-ray.at (view raw or flat)
Thread:
Lists: pgsql-cygwinpgsql-hackerspgsql-hackers-win32
Reini Urban schrieb:
> Cygwin can do symlinks for directories via the magic .lnk file.
> But Cygwin can also do junctions via hardlinks in ln.exe.
> I thought link() calls the junction code.
> I'll investigate why the libc link() failed, and if ln.exe does some 
> sifferent magic, similar to pgsymlink.

I thought a little bit over this.

hardlinks and junctions don't work across physical disks, only symlinks.
The whole deal about tablespace locations is to seperate it onto another 
disc, similar to the mysql innodb secondary storage. (or better db's)

For cygwin it is very easy to support symlinks to other discs.
Just use the native cygwin symlink(), not using the 
pgport/dirmode:pgsymlink() hook. Just some #define rename hackery at the 
beginning of the file.

For mingw and the other native WIN32 platforms, you can only support 
junctions (limited functionality, but fast) or go through the trouble of 
some symlink emulation. But different to the current pgsymlink code.
The only advantage is that this symlink resolver can be held in memory, 
just needs some dump/restore functions to a .conf file.
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

In response to

Responses

pgsql-cygwin by date

Next:From: Bruce MomjianDate: 2004-10-05 17:59:38
Subject: Re: win32 tablespace handing
Previous:From: Reini UrbanDate: 2004-10-05 16:23:28
Subject: Re: postgresql 8.0 and tsearch2 install under cygwin

pgsql-hackers by date

Next:From: Dann CorbitDate: 2004-10-05 17:47:11
Subject: Re: libpq and prepared statements progress for 8.0
Previous:From: David WheelerDate: 2004-10-05 17:31:53
Subject: Re: libpq and prepared statements progress for 8.0

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-10-05 17:59:38
Subject: Re: win32 tablespace handing
Previous:From: Bruce MomjianDate: 2004-10-05 16:35:15
Subject: Problem with Win32 pg_dump linking and symbols

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