Re: [pgsql-hackers-win32] Tablespaces

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [pgsql-hackers-win32] Tablespaces
Дата
Msg-id 200403041818.i24IIlF10795@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [pgsql-hackers-win32] Tablespaces  (tswan@idigx.com)
Ответы Re: [pgsql-hackers-win32] Tablespaces  (tswan@idigx.com)
Список pgsql-hackers
tswan@idigx.com wrote:
> > "Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> >>>> My feeling is that we need not support tablespaces on OS's without
> >>>> symlinks.
> >
> >> To create symlinked directories on Win2k NTFS see:
> >>     http://www.sysinternals.com/ntw2k/source/misc.shtml#junction
> >> I think Win2000 or XP would be a reasonable restriction for Win32 PG
> >> installations that want tablespaces.
> >
> > Oh, good --- symlinks for directories are all that we need for this
> > design.  I think that settles it then.
> >
>
> What archival tools are there that would restore this to this back to the
> filesystem: tar? zip?  What would happen if a symlink were removed or
> pointed to an invalid location while the postmaste was running?

Well, for backup, just run tar or find on /data with a flag to follow
symlinks, and you are done.  Can't get much easier than that.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

В списке pgsql-hackers по дате отправления:

Предыдущее
От: tswan@idigx.com
Дата:
Сообщение: Re: [pgsql-hackers-win32] Tablespaces
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Slony-I makes progress