[Nottingham] Pros/Cons to go -Fc or not -Fc for pg_dump ?

[Martin]

Folks,

For any of you worldly-wise postgres database freaks out there...


What comment might you have for which is the better for restoring
individual tables and for restoring all other cases for whichever of:


pg_dump -C -U "${u}" -w "${d}" | bzip2 -9 >"${b}"

or

pg_dump -Fc -Z 0 -U "${u}" -w "${d}" | bzip2 -9 >"${b}"


(where $u is user, $d the database name, $b target backup file)


... and then use sed or pg_restore as appropriate whenever recovery is
needed...


What is the 'best' way?

???


Cheers,
Martin



-- 
- ╔═══════════════════╦══════════════════════════════════════════╗
- ║   Martin Lomas    ║ OpenPGP (GPG/PGP) Public Key: 0xCEE1D3B7 ║
- ║ martin@ ml1 co uk ║ Import from   hkp://subkeys.pgp.net   or ║
- ║ ----------------- ║ http:// ml1 .co .uk/martin_ml1_co_uk.gpg ║
- ╚═══════════════════╩══════════════════════════════════════════╝