aboutsummaryrefslogtreecommitdiff
path: root/doc/src/FAQ/FAQ.html
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src/FAQ/FAQ.html')
-rw-r--r--doc/src/FAQ/FAQ.html42
1 files changed, 16 insertions, 26 deletions
diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html
index 4cd94ab4c41..477ca24a3c4 100644
--- a/doc/src/FAQ/FAQ.html
+++ b/doc/src/FAQ/FAQ.html
@@ -53,8 +53,8 @@
</CENTER>
<A href="#2.1">2.1</A>) Are there <SMALL>ODBC</SMALL> drivers for
PostgreSQL?<BR>
- <A href="#2.2">2.2</A>) What tools are available for hooking
- PostgreSQL to Web pages?<BR>
+ <A href="#2.2">2.2</A>) What tools are available for use PostgreSQL
+ with Web pages?<BR>
<A href="#2.3">2.3</A>) Does PostgreSQL have a graphical user
interface? A report generator? An embedded query language
interface?<BR>
@@ -77,14 +77,12 @@
accessing my PostgreSQL database?<BR>
<A href="#3.6">3.6</A>) Why can't I connect to my database from
another machine?<BR>
- <A href="#3.7">3.7</A>) All my servers crash under concurrent
- table access. Why?<BR>
- <A href="#3.8">3.8</A>) How do I tune the database engine for
+ <A href="#3.7">3.7</A>) How do I tune the database engine for
better performance?<BR>
- <A href="#3.9">3.9</A>) What debugging features are available?<BR>
- <A href="#3.10">3.10</A>) I get <I>"Sorry, too many clients"</I>
+ <A href="#3.8">3.8</A>) What debugging features are available?<BR>
+ <A href="#3.9">3.9</A>) I get <I>"Sorry, too many clients"</I>
when trying to connect. Why?<BR>
- <A href="#3.11">3.11</A>) What are the <I>pg_sorttempNNN.NN</I>
+ <A href="#3.10">3.10</A>) What are the <I>pg_sorttempNNN.NN</I>
files in my database directory?<BR>
@@ -260,10 +258,6 @@
<H4><A name="1.6">1.6</A>) Where can I get support?</H4>
- <P>There is no support for PostgreSQL from the University of
- California, Berkeley. It is maintained through volunteer
- effort.</P>
-
<P>The main mailing list is: <A href=
"mailto:pgsql-general@PostgreSQL.org">pgsql-general@PostgreSQL.org</A>.
It is available for discussion of matters pertaining to PostgreSQL.
@@ -316,7 +310,7 @@
<I>#PostgreSQL.</I> I use the unix command <CODE>irc -c
'#PostgreSQL' "$USER" irc.phoenix.net.</CODE></P>
- <P>A list of commercial PostgreSQL support is available at <A href=
+ <P>A list of commercial support companies is available at <A href=
"http://www.postgresql.org/users-lounge/commercial-support.html">http://www.postgresql.org/users-lounge/commercial-support.html</A>.</P>
<H4><A name="1.7">1.7</A>) What is the latest release?</H4>
@@ -508,8 +502,8 @@
"http://www.PostgreSQL.org/docs/programmer/odbc.htm">ODBC chapter
of the Programmer's Guide</A>.</P>
- <H4><A name="2.2">2.2</A>) What tools are available for hooking
- PostgreSQL to Web pages?</H4>
+ <H4><A name="2.2">2.2</A>) What tools are available for using
+ PostgreSQL with Web pages?</H4>
<P>A nice introduction to Database-backed Web pages can be seen at:
<A href="http://www.webtools.com">http://www.webtools.com</A></P>
@@ -620,6 +614,9 @@
modifying the file <I>$PGDATA/pg_hba.conf</I> accordingly. This
will allow TCP/IP connections.</P>
+ <P>Inoperative semaphores can also cause crashes during heavy
+ database access.</P>
+
<H4><A name="3.6">3.6</A>) Why can't I connect to my database from
another machine?</H4>
@@ -629,13 +626,7 @@
option, and add an appropriate host entry to the file
<I>pgsql/data/pg_hba.conf</I>.</P>
- <H4><A name="3.7">3.7</A>) All my servers crash under concurrent
- table access. Why?</H4>
-
- <P>This problem can be caused by a kernel that is not configured to
- support semaphores.</P>
-
- <H4><A name="3.8">3.8</A>) How do I tune the database engine for
+ <H4><A name="3.7">3.7</A>) How do I tune the database engine for
better performance?</H4>
<P>Certainly, indices can speed up queries. The
@@ -672,7 +663,7 @@
data in tables to match an index. See the <SMALL>CLUSTER</SMALL>
manual page for more details.</P>
- <H4><A name="3.9">3.9</A>) What debugging features are
+ <H4><A name="3.8">3.8</A>) What debugging features are
available?</H4>
<P>PostgreSQL has several features that report status information
@@ -728,7 +719,7 @@
in the <I>pgsql/data/base/dbname</I> directory. The client profile
file will be put in the client's current directory.</P>
- <H4><A name="3.10">3.10</A>) I get 'Sorry, too many clients' when
+ <H4><A name="3.9">3.9</A>) I get 'Sorry, too many clients' when
trying to connect. Why?</H4>
<P>You need to increase the <I>postmaster's</I> limit on how many
@@ -763,7 +754,7 @@
the MaxBackendId constant in
<I>include/storage/sinvaladt.h.</I></P>
- <H4><A name="3.11">3.11</A>) What are the <I>pg_sorttempNNN.NN</I>
+ <H4><A name="3.10">3.10</A>) What are the <I>pg_sorttempNNN.NN</I>
files in my database directory?</H4>
<P>They are temporary files generated by the query executor. For
@@ -1303,4 +1294,3 @@ or
compiler compute the dependencies automatically.</P>
</BODY>
</HTML>
-