From 1aa4a37f6a80e9707993f4a4796856ad5e4f04fc Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Fri, 11 Oct 2002 05:02:24 +0000
Subject: Add replication, encryption, and cross database FAQ items.

---
 doc/src/FAQ/FAQ.html | 24 +++++++++++++++++++++---
 1 file changed, 21 insertions(+), 3 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html
index a78c4167896..a412b67fa25 100644
--- a/doc/src/FAQ/FAQ.html
+++ b/doc/src/FAQ/FAQ.html
@@ -14,7 +14,7 @@
   alink="#0000ff">
     <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
 
-    <P>Last updated: Wed Oct  9 23:14:53 EDT 2002</P>
+    <P>Last updated: Fri Oct 11 00:59:31 EDT 2002</P>
 
     <P>Current maintainer: Bruce Momjian (<A href=
     "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
@@ -144,6 +144,7 @@
      <A href="#4.26">4.26</A>) Why can't I reliably create/drop
     temporary tables in PL/PgSQL functions?<BR>
      <A href="#4.27">4.27</A>) What replication options are available?<BR>
+     <A href="#4.28">4.28</A>) What encryption options are available?<BR>
      
 
     <H2 align="center">Extending PostgreSQL</H2>
@@ -1378,8 +1379,25 @@ BYTEA           bytea           variable-length byte array (null-byte safe)
     <H4><A name="4.27">4.27</A>) What replication options are available?
     </H4>
     <P>There are several master/slave replication solutions available.
-    These allow only one server to make database changes and the slave 
-    merely allow database reading.
+    These allow only the master to make database changes and the slave
+    can only do database reads. The bottom of <a
+    href="http://gborg.postgresql.org/genpage?replication_research">
+    http://gborg.postgresql.org/genpage?replication_research</a> lists
+    them. A multi-master replication solution is being worked on at <a
+    href="http://gborg.postgresql.org/project/pgreplication/projdisplay.
+    php">http://gborg.postgresql.org/project/pgreplication/projdisplay.php</a>.</P>
+
+    <H4><A name="4.27">4.27</A>) What encryption options are available?
+    </H4>
+    <UL>
+    <LI><I>/contrib/pgcrypto</I> contains many encryption functions for
+    use in <SMALL>SQL</SMALL> queries.</LI>
+    <LI>The only way to encrypt transmission from the client to the
+    server is by using <I>hostssl</I> in <I>pg_hba.conf</I>.</LI>
+    <LI>Database user passwords are automatically encrypted when stored
+    in version 7.3. In previous versions, you must enable
+    <I>password_encryption</I> in <I>postgresql.conf</I>.</LI>
+    </UL>
 
     <HR>
 
-- 
cgit v1.2.3