Thread: idea for a backup system...

Hello,
I'm new to the list ,but I have a question on a use of postgresql. I
need to know if this is dumb idea.

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.

Robert

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.

You should definitely look at "cvs" or at "subversion"
which would backup your site and would keep the history
off all the modifications.
(the wheel exists)

    franck.


Robert Boone wrote:
> Hello,
> I'm new to the list ,but I have a question on a use of postgresql. I
> need to know if this is dumb idea.
>
> 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.
>
> Robert
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

http://www.daemonnews.org/199903/websites.html

Robert Boone wrote:
> Hello,
> I'm new to the list ,but I have a question on a use of postgresql. I
> need to know if this is dumb idea.
>
> 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.
>
> Robert
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>