*wal-e version:* 0.7.2 (July 30th 2014)
So I was attempting to create a slave for my database, of which is backed
up with S3 (or so I thought). backup-fetch kept saying that it cannot find
"LATEST" and backup-list was displaying nothing.
I've got a bucket that looks like:
s3://website-db/wal_005/<thousands of files>
My crontab looks like:
0 2 * * * postgres envdir /etc/wal-e.d/env wal-e backup-push
/var/lib/postgresql/9.3/main
0 3 * * * postgres envdir /etc/wal-e.d/env wal-e delete --confirm retain 7
So I decide to try and run those commands manually in the hopes of seeing
some sort of errors or at least something happening. After running the
`backup-push` I see a new directory in my bucket:
s3://website-db/basebackups_005/<new folders and files>
s3://website-db/basebackups_005/<thousands of files>
Strange... I now have a new folder and backup-list is showing me one
entry... woop!
Next I run the `wal-e delete` command manually and it starts deleting allll
of the thousaaaaaands of files that were originally in my `wal_005`
directory, leaving me with 3 files.
So now I'm seeing a list of backups (success), I have some questions as to
what's going on. I'm assuming my cron stopped running at some point and
stopped creating backups... BUT! Why was this new directory only just
created (basebackups_005), of which allowed me to see a list of backups. I
was playing with AWS permissions and trying to open everything up, adding
policies etc to see if that helped me list backups, so guessing this might
have something to do with it.
Before running those commands manually I created the following bucket
policy (edited out potential sensitive info):
{
"Version": "2012-10-17",
"Id": "Policy1245472690462",
"Statement": [
{
"Sid": "Stmt1654472686672",
"Effect": "Allow",
"Principal": {
"AWS": "arn:aws:iam::123123123:user/john.smith"
},
"Action": [
"s3:ListBucket",
"s3:GetObject",
"s3:PutObject",
"s3:GetBucketLocation"
],
"Resource": [
"arn:aws:s3:::website-db/*",
"arn:aws:s3:::website-db"
]
}
]
}
Any ideas?
--
You received this message because you are subscribed to the Google Groups
"wal-e" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.