| From: | Thom Brown <thombrown(at)gmail(dot)com> |
|---|---|
| To: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
| Cc: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Shell script to Backup/Dump Database |
| Date: | 2010-05-12 16:07:30 |
| Message-ID: | AANLkTimlDfZRkUSQuGxh5Mb8nWbdA453NzWkts8Xj9VH@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12 May 2010 17:02, Andre Lopes <lopes80andre(at)gmail(dot)com> wrote:
> Thanks for the reply.
>
> I will test today.
>
> There are some good practices that I should do? For example, I have this
> database in a shared hosting, should I add the functionality of send the
> dumps by FTP to my PC once a week? Give some more ideias to avoid data loss
> in case of disaster.
>
> Best Regards,
>
>
Can you afford to lose 6 days worth of data? If not, get it to send backups
to another place on a daily basis. You can always add in an scp step to the
script to copy to another unix box, bearing in mind you'll need to add the
ssh key for the user on your shared host to ~/.ssh/authorized_hosts at your
destination. Or just use FTP like you mentioned.
Thom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | I. B. | 2010-05-12 16:08:36 | Persistence problem |
| Previous Message | Andre Lopes | 2010-05-12 16:02:07 | Re: Shell script to Backup/Dump Database |