Forum OpenACS Q&A: Re: File-Storage on PostgreSQL: Store files in the database or in the file-system

Collapse
4: Re: File-Storage on PostgreSQL: Store files in the database or in the file-system (response to 1)
Posted by Don Baccus on 03/10/04 06:48 PM
No, -Fp is fine because the driver's uuencoding the file data before storing it in the database.

-Fc requires use of pg_restore ... it may be that this utility, with its re-ordering capabilities, is robust to the point where we can trust it to properly restore an OpenACS site but when it first came out we didn't really trust it.

If it is trustworthy in all cases we *could* investigate using PG native LOBs again (they've also been improved).

Collapse
5: Re: File-Storage on PostgreSQL: Store files in the database or in the file-system (response to 4)
Posted by Dirk Gomez on 03/10/04 07:17 PM
OK, just wanted to make sure that backups are all fine - and that the default value for the above mentioned parameter makes sense.