[Fwd: Re: [HACKERS] Tablespaces] - Mailing list pgsql-hackers-win32

From Andreas Pflug
Subject [Fwd: Re: [HACKERS] Tablespaces]
Date
Msg-id 404C8997.1070006@pse-consulting.de
Whole thread Raw
List 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:

Previous
From: Claudio Natoli
Date:
Subject: Re: Win32 regression test status
Next
From: Bruce Momjian
Date:
Subject: Re: Win32 regression test status