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

Commit1aa4a37

Browse files
committed
Add replication, encryption, and cross database FAQ items.
1 parent3258484 commit1aa4a37

File tree

2 files changed

+49
-9
lines changed

2 files changed

+49
-9
lines changed

‎doc/FAQ‎

Lines changed: 28 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated:Wed Oct9 23:14:53 EDT 2002
4+
Last updated:Fri Oct11 00:59:31 EDT 2002
55

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

@@ -96,6 +96,8 @@
9696
4.25) How do I return multiple rows or columns from a function?
9797
4.26) Why can't I reliably create/drop temporary tables in PL/PgSQL
9898
functions?
99+
4.27) What replication options are available?
100+
4.28) What encryption options are available?
99101

100102
Extending PostgreSQL
101103

@@ -1046,12 +1048,13 @@ SELECT *
10461048

10471049
4.24) How do I perform queries using multiple databases?
10481050

1049-
There is no way to queryany databaseexceptthe current one. Because
1050-
PostgreSQL loads database-specific system catalogs, it is uncertain
1051-
how a cross-database query should even behave.
1051+
There is no way to querya databaseother thanthe current one.
1052+
BecausePostgreSQL loads database-specific system catalogs, it is
1053+
uncertainhow a cross-database query should even behave.
10521054

1053-
Of course, a client can make simultaneous connections to different
1054-
databases and merge the information that way.
1055+
/contrib/dblink allows cross-database queries using function calls. Of
1056+
course, a client can make simultaneous connections to different
1057+
databases and merge the results on the client side.
10551058

10561059
4.25) How do I return multiple rows or columns from a function?
10571060

@@ -1070,6 +1073,25 @@ SELECT *
10701073
the old temporary table. The solution is to use EXECUTE for temporary
10711074
table access in PL/PgSQL. This will cause the query to be reparsed
10721075
every time.
1076+
1077+
4.27) What replication options are available?
1078+
1079+
There are several master/slave replication solutions available. These
1080+
allow only the master to make database changes and the slave can only
1081+
do database reads. The bottom of
1082+
http://gborg.postgresql.org/genpage?replication_research lists them. A
1083+
multi-master replication solution is being worked on at
1084+
http://gborg.postgresql.org/project/pgreplication/projdisplay.php.
1085+
1086+
4.27) What encryption options are available?
1087+
1088+
* /contrib/pgcrypto contains many encryption functions for use in
1089+
SQL queries.
1090+
* The only way to encrypt transmission from the client to the server
1091+
is by using hostssl in pg_hba.conf.
1092+
* Database user passwords are automatically encrypted when stored in
1093+
version 7.3. In previous versions, you must enable
1094+
password_encryption in postgresql.conf.
10731095
_________________________________________________________________
10741096

10751097
Extending PostgreSQL

‎doc/src/FAQ/FAQ.html‎

Lines changed: 21 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@
1414
alink="#0000ff">
1515
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1616

17-
<P>Last updated:Wed Oct 9 23:14:53 EDT 2002</P>
17+
<P>Last updated:Fri Oct11 00:59:31 EDT 2002</P>
1818

1919
<P>Current maintainer: Bruce Momjian (<Ahref=
2020
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
@@ -144,6 +144,7 @@ <H2 align="center">Operational Questions</H2>
144144
<Ahref="#4.26">4.26</A>) Why can't I reliably create/drop
145145
temporary tables in PL/PgSQL functions?<BR>
146146
<Ahref="#4.27">4.27</A>) What replication options are available?<BR>
147+
<Ahref="#4.28">4.28</A>) What encryption options are available?<BR>
147148

148149

149150
<H2align="center">Extending PostgreSQL</H2>
@@ -1378,8 +1379,25 @@ <H4><A name="4.26">4.26</A>) Why can't I reliably create/drop
13781379
<H4><Aname="4.27">4.27</A>) What replication options are available?
13791380
</H4>
13801381
<P>There are several master/slave replication solutions available.
1381-
These allow only one server to make database changes and the slave
1382-
merely allow database reading.
1382+
These allow only the master to make database changes and the slave
1383+
can only do database reads. The bottom of<a
1384+
href="http://gborg.postgresql.org/genpage?replication_research">
1385+
http://gborg.postgresql.org/genpage?replication_research</a> lists
1386+
them. A multi-master replication solution is being worked on at<a
1387+
href="http://gborg.postgresql.org/project/pgreplication/projdisplay.
1388+
php">http://gborg.postgresql.org/project/pgreplication/projdisplay.php</a>.</P>
1389+
1390+
<H4><Aname="4.27">4.27</A>) What encryption options are available?
1391+
</H4>
1392+
<UL>
1393+
<LI><I>/contrib/pgcrypto</I> contains many encryption functions for
1394+
use in<SMALL>SQL</SMALL> queries.</LI>
1395+
<LI>The only way to encrypt transmission from the client to the
1396+
server is by using<I>hostssl</I> in<I>pg_hba.conf</I>.</LI>
1397+
<LI>Database user passwords are automatically encrypted when stored
1398+
in version 7.3. In previous versions, you must enable
1399+
<I>password_encryption</I> in<I>postgresql.conf</I>.</LI>
1400+
</UL>
13831401

13841402
<HR>
13851403

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp