backups and restores: -Fc vs. -Ft

Поиск

Список

Период

Сортировка

От	Josh Goldberg
Тема	backups and restores: -Fc vs. -Ft
Дата	29 апреля 2003 г. 18:28:09
Msg-id	0e1501c30e9e$736ef8e0$6e02a8c0@4dmatrix.com обсуждение исходный текст
Ответы	REMOVE
Список	pgsql-admin

Дерево обсуждения

All this talk lately about problems using -Ft when restoring backups...I've always used -Fc. What other advantages/disadvantages are there to using the custom format as opposed to the tar format, besides the fact that tar has never reliably worked for me? Why are all you other admins (seemingly) dependent on having tar working, besides that it's really really cool when everything works as expected?

Thanks in advance for the enlightenment :-)

p.s. - fyi, here's my backup/restore method (I don't use the contrib lo, I just use the regular built-in stuff.):

pg_dump -Fc -obf dumpfile -U mysuer mydatabase

pg_restore -Fc -s -U myuser -d mydatabase dumpfile

pg_restore -Fc -ao -U myuser -d mydatabase dumpfile

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

backups and restores: -Fc vs. -Ft