PITR for an only object in postgres

2021-03-18 Thread aslı cokay
Hi all,

Is there any way to get for example a table version of 5 minutes ago, or we
should PITR to 5 minutes ago, dump the table and restore with this dump ?

Thanks.


WAL-G shipping to the cloud

2021-03-18 Thread aslı cokay
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?

Thanks.