Re: WAL-G shipping to the cloud

Hi,
I'm using Wal-G like this, in pg12:

archive_mode = always
> archive_command = 'wal-g wal-push %p'
> archive_timeout = 60
> restore_command = 'wal-g wal-fetch %f %p'

The only change for pg10 is last line (restore_command) has to go into a
separate file, recovery.conf.

Please note, however, I'm using this in Kubernetes, so the relevant docker
image has already got all the relevant ENV config for Wall-G loaded
beforehand.
But Wal-G is really straightforward to configure, however.

Adalberto

Il giorno ven 19 mar 2021 alle ore 00:30 asli cokay <aslicokay(at)gmail(dot)com>
ha scritto:

> Thank you, Bruce. Actually I mean I am using WAL-G what I am curious about
> is that I want to test shipping process automate, and I am looking for the
> ideas. But thanks for your help.
>
> Bruce Momjian <bruce(at)momjian(dot)us>, 18 Mar 2021 Per, 17:24 tarihinde şunu
> yazdı:
>
>> On Thu, Mar 18, 2021 at 05:18:30PM -0400, aslı cokay wrote:
>> > Hi all,
>> >
>> > I'd like to get postgres log files to the cloud but i want this process
>> going
>> > live i want to automate test process and after that i want it go live.
>> >
>> > What i have in my mind is setting archive_mode is on and
>> archiving_command with
>> > a script. After that i want to execute pgbench to get more WAL files and
>> > trigger with pg_switch_wal() to change WAL files.
>> >
>> > Is there any idea do you have about it or is there anyone shipped their
>> log to
>> > the cloud to give me an idea?
>>
>> Well, there is Wal-E and Wal-G, which archive to the cloud.
>> pg_backreset also supports cloud WAL storage.
>>
>> --
>> Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
>> EDB https://enterprisedb.com
>>
>> If only the physical world exists, free will is an illusion.
>>
>>