How can I use WAL-E to keep a continuous backup of my heroku postgresql DB?

[bidu...@gmail.com]

Hi,

Reading the documentation I see wal-e must be installed on the same machine as the DB resides. However, I wan't to keep my Postgresql instance under heroku backed up. Is that possivle achieving this using WAL-E?

Best,

Pedro.

[Daniel Farina]

On Mon, Mar 28, 2016 at 11:17 AM <bidu...@gmail.com> wrote:

Hi,

Reading the documentation I see wal-e must be installed on the same machine as the DB resides. However, I wan't to keep my Postgresql instance under heroku backed up. Is that possivle achieving this using WAL-E?

Heroku uses WAL-E. I wrote the original versions to Heroku's purposes.

[Pedro]

Hi Daniel,

Thanks a lot for the fast response.

Ok, I know it uses WAL-E, but as far as I could realize it uses WAL-E for internal operations, like create a fork or keep a follower sync, I'd like to route the archiving to my AWS S3 bucket. Is that possible?

Best,

Pedro.

[Daniel Farina]

On Mon, Mar 28, 2016 at 11:53 AM Pedro <bidu...@gmail.com> wrote:

Hi Daniel,

Thanks a lot for the fast response.

Ok, I know it uses WAL-E, but as far as I could realize it uses WAL-E for internal operations, like create a fork or keep a follower sync, I'd like to route the archiving to my AWS S3 bucket. Is that possible?

Well, I don't work there anymore, you'd have to ask them. Generally the answer is no, for several reasons. 

[Pedro]

Already did it, waiting for them to reply.

[Snehal Sandran]

Hi Pedro,

did you able to find any solution?

[Christophe Pettus]

> On Jul 19, 2021, at 11:17, Snehal Sandran <snehal....@searce.com> wrote:
>
> Hi Pedro,
>
> did you able to find any solution?

Although I wouldn't claim to speak for Heroku, Heroku generally does not allow you the level of access required to run your own separate WAL archiving solution in addition to theirs.

[Snehal Sandran]

Ok, thanks. 

[Snehal Sandran]

Hi,

Please check this link:

https://vericred.github.io/2020/08/10/migrating-to-aurora.html

It has given an example to migrate the Heroku Postgres to AWS Aurora.