*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.

Reply via email to