On Mar 4, 2006, at 7:04 , Redefined Horizons wrote:
> P.S. - I still have some sections to complete on the article about
> automatic backups. I was also wondering, what is the -c switch used
> for? What type of custom format would you export in a postgreSQL
> backup?
Are you referring to the -Fc flag for pg_dump? Something that I was
recently made aware of was this[1]:
> Output a custom archive suitable for input into pg_restore. This is
> the most flexible format in that it allows reordering of loading
> data as well as object definitions. This format is also compressed
> by default.
You can use the --list and --use-list flags for pg_restore[2] to take
advantage of the custom format dump file.
Hope this helps.
Michael Glaesemann
grzm myrealbox com
[1](http://www.postgresql.org/docs/current/interactive/app-pgdump.html)
[2](http://www.postgresql.org/docs/current/interactive/app-
pgrestore.html)