A
A
Alexander Vishnev2018-09-22 18:01:58
PostgreSQL
Alexander Vishnev, 2018-09-22 18:01:58

How to make one database (on Postgres) on two physically separate servers?

How to make one database (Postgres) on two physically separate servers?
Those. we have two servers. Each server has 400 GB of disk space. The database is over 400 GB i.e. it is necessary that when the database reaches a certain size (for example, 370GB) on server 1, the data is automatically uploaded to server 2. And when a request (for example, select blablabla) to server 1, the data is also "sniffed" from server 2.
Google queries on the topic clustering and replication, but I did not find articles for my task.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Sergey Gornostaev, 2018-09-22
@fromdns

Google about sharding.

K
Konstantin, 2018-09-23
@happy_yar

https://www.citusdata.com

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question