backups and restores: -Fc vs. -Ft

Поиск
Список
Период
Сортировка
От Josh Goldberg
Тема backups and restores: -Fc vs. -Ft
Дата
Msg-id 0e1501c30e9e$736ef8e0$6e02a8c0@4dmatrix.com
обсуждение исходный текст
Ответы REMOVE  (Chad Oblak <chad@freeshell.org>)
Список 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 по дате отправления:

Предыдущее
От: Juan Miguel
Дата:
Сообщение: Re: Fw: Postgres 7.3, pg_dump, pg_restore and "lo" type
Следующее
От: Chad Oblak
Дата:
Сообщение: REMOVE