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

[Fwd: Re: [HACKERS] Tablespaces]

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: PostgreSQL Win32 port list <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: [Fwd: Re: [HACKERS] Tablespaces]
Date: 2004-03-08 14:56:23
Message-ID: 404C8997.1070006@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-hackers-win32

Andrew Sullivan wrote:

>eorganise the disks", assuming that the database
>just has its own home.  For such a sysadmin, a pile of symlinks would
>be fair game for reorganisation.
>  
>

Please take into consideration that symlinks might be every day work for 
*nix admins, but for win admins it's very uncommon. Additionally, win 
admins are accustomed to gui tools, and many of them will stumble if 
forced to use a command line. For worse, junctions are not 
distinguishable in explorer; only the shell's dir command knows about 
junctions. This obfuscation makes junctions quite a bad choice for admin 
purposes.

IMHO there are only two viable options:
- no tablespaces for win32, i.e. recommend *ix for bigger installations
- a different tablespace storage approach., e.g. simple desktop links 
(or alike) redirecting to a directory.


Regards,
Andreas





pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-03-08 17:30:41
Subject: Re: Tablespaces
Previous:From: Andreas PflugDate: 2004-03-08 13:56:46
Subject: Re: Tablespaces

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