Thread: idea for a backup system...

idea for a backup system...

From
Robert Boone
Date:
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


Re: idea for a backup system...

From
"Shridhar Daithankar"
Date:
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.


Re: backup system

From
frbn
Date:
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
>


Re: idea for a backup system...

From
frbn
Date:
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
>