On 26 Jan 2003 at 21:01, Robert Boone wrote:
> I want to use postgresql to backup a web server. I could do a lo_import
> on each and every file in the document root by writing a perl script.
> Then when I wanted a file I can grab it with an sql statement. Is this
> even close to a good idea? Of course, other things would need to be
> worked out like backing up the database to tape. I think it would be a
> pretty good idea, but I have been wrong before. Thanks for the help.
I would say this is not the best of available solutions. If you can afford
another backup machine, rsync+tar->tape/CD-R would be a better backup solution.
Just my opinion..
Bye
Shridhar
--
patent: A method of publicizing inventions so others can copy them.