|
10 | 10 | alink="#0000ff"> |
11 | 11 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
12 | 12 |
|
13 | | -<P>Last updated:Wed May4 21:42:01 EDT 2005</P> |
| 13 | +<P>Last updated:Mon May9 13:15:04 EDT 2005</P> |
14 | 14 |
|
15 | 15 | <P>Current maintainer: Bruce Momjian (<Ahref= |
16 | 16 | "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>) |
@@ -115,8 +115,7 @@ <H2 align="center">Operational Questions</H2> |
115 | 115 | <Ahref="#4.19">4.19</A>) Why do I get "relation with OID ##### |
116 | 116 | does not exist" errors when accessing temporary tables in PL/PgSQL |
117 | 117 | functions?<BR> |
118 | | -<Ahref="#4.20">4.20</A>) What encryption options are available?<BR> |
119 | | -<Ahref="#4.21">4.21</A>) What replication solutions are available?<BR> |
| 118 | +<Ahref="#4.20">4.20</A>) What replication solutions are available?<BR> |
120 | 119 |
|
121 | 120 |
|
122 | 121 | <HR> |
@@ -980,24 +979,7 @@ <H3><A name="4.19">4.19</A>) Why do I get "relation with OID ##### |
980 | 979 | <SMALL>EXECUTE</SMALL> for temporary table access in PL/PgSQL. This |
981 | 980 | will cause the query to be reparsed every time.</P> |
982 | 981 |
|
983 | | -<H3><Aname="4.20">4.20</A>) What encryption options are available? |
984 | | -</H3> |
985 | | -<UL> |
986 | | -<LI><I>contrib/pgcrypto</I> contains many encryption functions for |
987 | | - use in<SMALL>SQL</SMALL> queries.</LI> |
988 | | -<LI>To encrypt transmission from the client to the server, the server |
989 | | - must have the<I>ssl</I> option set to<I>true</I> in<I>postgresql.conf, |
990 | | -</I> and an applicable<I>host</I> or<I>hostssl</I> record must exist in |
991 | | -<I>pg_hba.conf</I>, and the client<I>sslmode</I> must not be |
992 | | -<I>disable.</I> (Note that it is also possible to use a third-party |
993 | | - encrypted transport, such as stunnel or ssh, rather than PostgreSQL's |
994 | | - native SSL connections.)</LI> |
995 | | -<LI>Database user passwords are automatically encrypted when stored in |
996 | | - the system tables.</LI> |
997 | | -<LI>The server can also run using an encrypted file system.</LI> |
998 | | -</UL> |
999 | | - |
1000 | | -<H3><Aname="4.21">4.21</A>) What replication solutions are available? |
| 982 | +<H3><Aname="4.20">4.20</A>) What replication solutions are available? |
1001 | 983 | </H3> |
1002 | 984 |
|
1003 | 985 | <P>Though "replication" is a single term, there are several technologies |
|