Обсуждение: backups and restores: -Fc vs. -Ft
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
REMOVE On Tue, 29 Apr 2003, Josh Goldberg wrote: > Date: Tue, 29 Apr 2003 15:26:59 -0700 > From: Josh Goldberg <josh@4dmatrix.com> > To: postgres-admin <pgsql-admin@postgresql.org> > Subject: [ADMIN] backups and restores: -Fc vs. -Ft > > All this talk lately about problems using -Ft when restoring backups...I've always used -Fc. What other advantages/disadvantagesare there to using the custom format as opposed to the tar format, besides the fact that tar hasnever reliably worked for me? Why are all you other admins (seemingly) dependent on having tar working, besides thatit'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 > >