postgresql - What is the best way to setup postgres replication for the following constraints? -


i have developed web application locally has plenty of data wrangling. db server use postgresql 9.5. deploying low powered digitalocean droplet. still need continual updates data. of processing droplet. local machine more powerful.

so plan have local database read , update. updates should propagated droplet. local server master , db slave. should noted there other applications running on server , data resides separate databases in same postgresql server. constraint is, machine local server resides on not have dedicated ip. issue?

the db server stores user submitted data. there write web app though not heavy , not overlap tables residing in local machine.

i looked @ postgresql documentation on replication https://www.postgresql.org/docs/9.1/static/different-replication-solutions.html not sure option appropriate. since 1 person operation, keep simple.

i discounting warm-and-hot standby indicated whole database server replication.

"trigger-based master-standby replication" indicates slave read writes on tables not overlap master server has. not sure if possible.

i appreciate advice. thank you.


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -