Re: db backup script in gentoo

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: db backup script in gentoo
Date: 2008-12-01 12:27:05
Message-ID: 7F46EEBABCBF495C9D702086A00E1C77@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott,

>OK, find out how to create users on your gentoo server, and see if you
>can figure out what's broken in emerge so you can install lftp. It's
>much better than regular ftp, as it has assured transfer completion
>and other useful features if you're interested in making sure the file
>gets transferred. Or switch to rsync, which is how I do it.

ftp exists in windows also.
So I can create protable scripts which works in linux/windows probably.
Backup ftp server is located in ISP (probably Debian) which offers ftp and
http access.
So it seems that I cannot use rsync.

Unresolved is rotating issue:

This script creates different backup file for every weekday containing
weekday number in name.
ftp account in ISP is public account which allows only to upload files, not
to overwrite existing ones or download them.
So backup fails after a week if files are not deleted manually.

How to use http POST command to send backup to this server? In this case it
may be possible to create php script in server which
handles rotating. Or any other idea ?

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-12-01 12:32:10 Re: configure options
Previous Message Siddharth Shah 2008-12-01 12:26:19 Re: configure options