diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-10-11 05:02:24 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-10-11 05:02:24 +0000 |
| commit | 1aa4a37f6a80e9707993f4a4796856ad5e4f04fc (patch) | |
| tree | 3d0116b70a78801beaa64403e0304bdd85f5d341 /doc/src/FAQ | |
| parent | 3258484d032c26bf45e00c304e2cb178ff291812 (diff) | |
| download | postgresql-1aa4a37f6a80e9707993f4a4796856ad5e4f04fc.tar.gz postgresql-1aa4a37f6a80e9707993f4a4796856ad5e4f04fc.zip | |
Add replication, encryption, and cross database FAQ items.
Diffstat (limited to 'doc/src/FAQ')
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 24 |
1 files changed, 21 insertions, 3 deletions
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> |