Forums

First of all, I’m not very experienced in database administration, so I apologize if my question seems basic or unclear.

My ultimate goal is to use a BI tool with my data; however, I can't connect directly to the database on PythonAnywhere, as SSH connections are not supported in this tool.
Therefore, my idea is to create a copy of the database in my service and sync it with another database. Ideally, I’d like to automate this process, with some acceptable delay (e.g., a one-day lag is fine).

I found a method called Streaming Replication, where I would configure the source database and set up the target database as a standby replica.
My question is: is it possible to configure parameters like
wal_level = replica max_wal_senders = 3
on PythonAnywhere?

And after all manipulations, will this method work?

If anyone knows of a better way to sync my database, I’d appreciate any suggestions in this thread. Thank you!

I always have my plan B: it’s to create a Python script that transfers data from one database to another, but I’d like something more efficient.

This is the basic backup process for postgres we recommend, could you have a look and check if that would achieve what you need?

Actually, it works even for automation. Thank you!

Great, glad we could help!