Forums

I'm wondering if it's possible to configure streaming replication for our Postgres database. Today we do scheduled daily backups offsite to S3 but I've been thinking it would also be nice to set up a sister account in EU.pythonanywhere.com and have it serve as a standby in the event the US infrastructure has an extended outage or a long maintenance window.

Could you provide more details on how you'd like to implement it? Did you try to test it already? (If changes in the configuration require a reboot of the postgres instance, we have to do it for you.)

Can we set up replication. I am also trying to replicate my Postgres database, but nothing is happening. It looks like it has set up the publication and subscription in pgAdmin4, but I get 0 rows when I run select * from pg_catalog.pg_publication;. Are we allowed to set up replication?

I think this would be a very reasonable thing but unfortunately not possible with our current infrastructure. The two databases wouldnt be able to talk to eachother

Not doubting you, but want to know why can't the two databases talk to each other if they are both on your postgres server?

We do not expose the user databases to the internet, so the 2 servers are not visible to each other without using an SSH tunnel. The EU infrastructure is entirely separate from the US infrastructure.