Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit7a35c63

Browse files
committed
Add replication FAQ item.
1 parent947eb97 commit7a35c63

File tree

2 files changed

+29
-2
lines changed

2 files changed

+29
-2
lines changed

‎doc/FAQ

Lines changed: 14 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: Sun Apr 24 07:27:43 EDT 2005
4+
Last updated: Sun Apr 24 07:48:48 EDT 2005
55

66
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77

@@ -78,6 +78,7 @@
7878
4.19) Why do I get "relation with OID ##### does not exist" errors
7979
when accessing temporary tables in PL/PgSQL functions?
8080
4.20) What encryption options are available?
81+
4.21) What replication solutions are available?
8182
_________________________________________________________________
8283

8384
General Questions
@@ -755,3 +756,15 @@
755756
* Database user passwords are automatically encrypted when stored in
756757
the system tables.
757758
* The server can also run using an encrypted file system.
759+
760+
4.21) What replication solutions are available?
761+
762+
Though "replication" is a single term, there are two major replication
763+
technologies. Multi-master replication allows read/write queries to be
764+
sent to multiple replicated computers. This capability has a serious
765+
performance impact. Pgcluster is the most popular such solution
766+
available for PostgreSQL. Master-slave replication allows a single
767+
master to receive read/write queries, with slaves able to accept only
768+
read/SELECT queries. The most popular master-slave PostgreSQL
769+
replication solution is Slony. There are also commercial and
770+
hardware-based replication solutions available.

‎doc/src/FAQ/FAQ.html

Lines changed: 15 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated: Sun Apr 24 07:27:43 EDT 2005</P>
13+
<P>Last updated: Sun Apr 24 07:48:48 EDT 2005</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)
@@ -115,6 +115,7 @@ <H2 align="center">Operational Questions</H2>
115115
does not exist" errors when accessing temporary tables in PL/PgSQL
116116
functions?<BR>
117117
<Ahref="#4.20">4.20</A>) What encryption options are available?<BR>
118+
<Ahref="#4.21">4.21</A>) What replication solutions are available?<BR>
118119

119120

120121
<HR>
@@ -984,5 +985,18 @@ <H3><A name="4.20">4.20</A>) What encryption options are available?
984985
<LI>The server can also run using an encrypted file system.</LI>
985986
</UL>
986987

988+
<H3><Aname="4.21">4.21</A>) What replication solutions are available?
989+
</H3>
990+
<P>Though "replication" is a single term, there are two major replication
991+
technologies. Multi-master replication allows read/write queries to be
992+
sent to multiple replicated computers. This capability has a
993+
serious performance impact.<Ahref="http://pgfoundry.org/projects/pgcluster/">
994+
Pgcluster</A> is the most popular such solution available for PostgreSQL.
995+
Master-slave replication allows a single master to receive read/write
996+
queries, with slaves able to accept only read/<SMALL>SELECT</SMALL> queries.
997+
The most popular master-slave PostgreSQL replication solution is
998+
<Ahref="http://gborg.postgresql.org/project/slony1/projdisplay.php">
999+
Slony</A>. There are also commercial and hardware-based replication
1000+
solutions available.</P>
9871001
</BODY>
9881002
</HTML>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp