Is it possible to FileStream from Postgres (Neon) to B2 without temp storage?

How it works
1

Is it possible to FileStream from Postgres (Neon) to B2 without temp storage?

I have a database that is around 600GB but will likely be a few TB soon, I want to stream the backup directly into B2, without having to first download it locally to temp space then upload it. Is that possible?

I looked around the settings and couldn’t find anything unless this requires a custom flag.

2

I read the documentation and learned this is not possible. Also does not seem like a good idea to perform either.

I have learned that Postgres Incremental backups are coming and is in active development with SQLBackupandFTP! We use Postgres v17.3 so looking forward to this upcoming feature!

3

Hello,

Thank you for your message.

Unfortunately, streaming a PostgreSQL backup directly from Neon to B2 without using temporary local storage isn’t currently possible.

That said, good news: the version of SQLBackupAndFTP with PostgreSQL incremental backup support is now available!
You can download the alpha build here:
:link: https://sqlbackupandftp.com/download/alpha.