Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.
Дата
Msg-id 1362686160.81979.YahooMailNeo@web162903.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.  (<fburgess@radiantblue.com>)
Список pgsql-bugs
"fburgess@radiantblue.com" <fburgess@radiantblue.com> wrote:=0A=0A> It look=
s like this script deletes all of the data file=0A> directories (and the da=
ta files) from the postgres 8.4.3=0A> instance. Since we used the "-k" opti=
on, which calls for hard=0A> links rather than copying files to the new clu=
ster, wouldn't this=0A> be deleting the files?=A0 If so, the DB would be co=
rrupted beyond=0A> recovery if we run it.=A0 Or am I missing something?=0A=
=0AYou need to read up on hard links a bit more.=A0 Here's one source:=0A=
=0Ahttp://www.linfo.org/hard_link.html=0A=0AIn summary, a hard link allows =
multiple directory entries to point=0Ato the same data location.=A0 Until y=
ou delete the last directory=0Aentry the file remains.=0A=0A-- =0AKevin Gri=
ttner=0AEnterpriseDB: http://www.enterprisedb.com=0AThe Enterprise PostgreS=
QL Company

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

Предыдущее
От:
Дата:
Сообщение: Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.
Следующее
От: Josh Kupershmidt
Дата:
Сообщение: Re: BUG #7873: pg_restore --clean tries to drop tables that don't exist