Re: idea for a backup system... - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: idea for a backup system...
Date
Msg-id 3E3520C4.10329.98B5DC5@localhost
Whole thread Raw
In response to idea for a backup system...  (Robert Boone <robert@rlb3.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Re: I was spoiled by the MySQL timestamp field
Next
From: will trillich
Date:
Subject: Re: hot to determine calculated fields (views)