[Pgpool-hackers] tutorial-zh_cn.html almost finished with some problem

[Tatsuo Ishii]

> Hi, every one.
>     I have almost finished translation tutorial-en.html from pgpool-II
> 3.1 alpha to a simplified Chinese version, while there's something
> need your help. Could anyone help me ?
>     The following are the sentences from the document and my question.
>     1.Moreover, the same data as two or more data base nodes can be
> reproduced with partitioning.
>                                             ^^   should be 'at' or others ?

Wao, this is totally confusing. I would like to rephrase the sentence
like following:

Moreover you could replicate some of tables among database nodes even
in the parallel query mode.

>     2.The data base made by Moreover, because the composition of the
> data stored in the data base is different in ...
>        ^^^^^^^^^^^^^^^^^^^^^^^^^^^ What does these means ?

Again, this paragraph is totally confusing. I would like to rephrase:

Attention: You can have both partitioned tables and replicated
tables. However a table cannot be a partioned and replicated one at
the same time. Because the data structure of partioned tables and
replicated tables are different, "bench_replication" database created
in section "2. <a href="#replication">Your First Replication</a>"
cannot be reused in parallel query mode.</p>

>     3.Moreover, the data base node One can make the system data base,
> and pgpool-II can be distributed in the load by connecting the
> cascade.

Again, this paragraph is totally confusing. I would like to rephrase:

<p> "System database" is just an ordinaly database. The only
requirement is, dblink functions and the dist_def table, which
describes partioning rule, must be installed in the system
database. You could have system database on a database node, or you
could have multiple node having system database by using cascade
configuration of pgpool-II.  </p>

>       Dose this means we should build SystemDB in node 1, and then
> connect all database node use pgpool-II

If you have two database nodes, you need to have 1 more database node
which has the system database.

>     4.When the table that does the replication to one SQL sentence
> with the table registered in dist_def by uniting tables is specified
> 
> 
>            ^^^^^^ I don't understand this
>     Thanks.
>     Bambo Huang

<h4><p>3.2.2. Defining replicate_def table</p></h4>
<p>
When the table that does the replication to one SQL sentence with the
table registered in dist_def by uniting tables is specified,
information on the table that does the replication (replication rule)
is registered in the table named replicate_def beforehand.

I rephrase this:

<h4><p>3.2.2. Defining replicate_def table</p></h4> <p> Define a table
called "dist_def", which has the partitioning rule, in database called
"pgpool" (it seems this sentence was translated from Japanese doc).

After installing pgpool-II, you will have <code>system_db.sql</code>,
which is the <code>psql</code> script to generate the system database.
</p>
<pre>
$ psql -f /usr/local/share/system_db.sql -p 5432 -U pgpool pgpool
</pre>
<p>
dist_def table is created in pgpool_catalog schema.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp