I m从事一个项目,需要在若干实际地点共享邮政ql数据库。 每个地点的联系有限,只能每天一次或两次进入外部世界。 因此,数据库必须在每个地点当地提供,但也必须尽可能与主数据库同步。
我尚未熟悉复制或集群做法。 这些好的解决办法吗? 还是有更好的方式这样做? 请就此提出一些建议。
注:不同地点的主要钥匙相互冲突不会是一个问题,这个问题已经得到了注意。
如果偏远地区需要即可获得数据,则你可以很容易地利用,这是PogreSQL的一个内在特征。 在这种配置中,主机将WAL(rite头记录)档案投放到一个共用地点,在那里,远程服务器可以定期连接,并阅读记录,以便更新。
如果所有服务器都独立进行书写,那么你所期待的是synchronous multi-masterplica。 The Postgres docs reference Bucardo 和rubyrep,作为实现这一目标的备选办法。 根据该书,两者都限于主人对手复制(或多奴隶主复制),但Bucardo据称确实计划复制5版,而Wilyrep则提到“method,用于保持多个服务器同步。
(I have servers using PostgreSQL s log shipping and streaming replication features, but I have no direct experience with Bucardo or rubyrep.)
我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。
On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...
I ll take the simplest of the SQL functions as an example: CREATE OR REPLACE FUNCTION skater_name_match(INTEGER,VARCHAR) RETURNS BOOL AS $$ SELECT $1 IN (SELECT skaters_skater.competitor_ptr_id ...
I m 在当地网络上运行几台机器,在Salgresql8.3处撰写一份申请。
I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.
Hey, I have 2 tables in PostgreSql: 1 - documents: id, title 2 - updates: id, document_id, date and some data: documents: | 1 | Test Title | updates: | 1 | 1 | 2006-01-01 | | 2 | 1 | 2007-01-01 |...
I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...
I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...
