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

Commitc0bb21b

Browse files
committed
Update FAQ.
1 parentd90703a commitc0bb21b

File tree

2 files changed

+30
-46
lines changed

2 files changed

+30
-46
lines changed

‎doc/FAQ‎

Lines changed: 14 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -32,7 +32,7 @@
3232
User Client Questions
3333

3434
2.1) Are there ODBC drivers for PostgreSQL?
35-
2.2) What tools are available forhooking PostgreSQLto Web pages?
35+
2.2) What tools are available foruse PostgreSQLwith Web pages?
3636
2.3) Does PostgreSQL have a graphical user interface? A report
3737
generator? An embedded query language interface?
3838
2.4) What languages are available to communicate with PostgreSQL?
@@ -50,11 +50,10 @@
5050
3.5) How do I prevent other hosts from accessing my PostgreSQL
5151
database?
5252
3.6) Why can't I connect to my database from another machine?
53-
3.7) All my servers crash under concurrent table access. Why?
54-
3.8) How do I tune the database engine for better performance?
55-
3.9) What debugging features are available?
56-
3.10) I get "Sorry, too many clients" when trying to connect. Why?
57-
3.11) What are the pg_sorttempNNN.NN files in my database directory?
53+
3.7) How do I tune the database engine for better performance?
54+
3.8) What debugging features are available?
55+
3.9) I get "Sorry, too many clients" when trying to connect. Why?
56+
3.10) What are the pg_sorttempNNN.NN files in my database directory?
5857

5958
Operational Questions
6059

@@ -197,9 +196,6 @@
197196

198197
1.6) Where can I get support?
199198

200-
There is no support for PostgreSQL from the University of California,
201-
Berkeley. It is maintained through volunteer effort.
202-
203199
The main mailing list is: pgsql-general@PostgreSQL.org. It is
204200
available for discussion of matters pertaining to PostgreSQL. To
205201
subscribe, send mail with the following lines in the body (not the
@@ -236,7 +232,7 @@
236232
There is also an IRC channel on EFNet, channel #PostgreSQL. I use the
237233
unix command irc -c '#PostgreSQL' "$USER" irc.phoenix.net.
238234

239-
A list of commercialPostgreSQLsupport is available at
235+
A list of commercial support companies is available at
240236
http://www.postgresql.org/users-lounge/commercial-support.html.
241237

242238
1.7) What is the latest release?
@@ -385,7 +381,7 @@
385381

386382
See also the ODBC chapter of the Programmer's Guide.
387383

388-
2.2) What tools are available forhooking PostgreSQLto Web pages?
384+
2.2) What tools are available forusing PostgreSQLwith Web pages?
389385

390386
A nice introduction to Database-backed Web pages can be seen at:
391387
http://www.webtools.com
@@ -469,19 +465,17 @@
469465
authentication by modifying the file $PGDATA/pg_hba.conf accordingly.
470466
This will allow TCP/IP connections.
471467

468+
Inoperative semaphores can also cause crashes during heavy database
469+
access.
470+
472471
3.6) Why can't I connect to my database from another machine?
473472

474473
The default configuration allows only unix domain socket connections
475474
from the local machine. To enable TCP/IP connections, make sure the
476475
postmaster has been started with the -i option, and add an appropriate
477476
host entry to the file pgsql/data/pg_hba.conf.
478477

479-
3.7) All my servers crash under concurrent table access. Why?
480-
481-
This problem can be caused by a kernel that is not configured to
482-
support semaphores.
483-
484-
3.8) How do I tune the database engine for better performance?
478+
3.7) How do I tune the database engine for better performance?
485479

486480
Certainly, indices can speed up queries. The EXPLAIN command allows
487481
you to see how PostgreSQL is interpreting your query, and which
@@ -512,7 +506,7 @@
512506
You can also use the CLUSTER command to group data in tables to match
513507
an index. See the CLUSTER manual page for more details.
514508

515-
3.9) What debugging features are available?
509+
3.8) What debugging features are available?
516510

517511
PostgreSQL has several features that report status information that
518512
can be valuable for debugging purposes.
@@ -559,7 +553,7 @@
559553
pgsql/data/base/dbname directory. The client profile file will be put
560554
in the client's current directory.
561555

562-
3.10) I get 'Sorry, too many clients' when trying to connect. Why?
556+
3.9) I get 'Sorry, too many clients' when trying to connect. Why?
563557

564558
You need to increase the postmaster's limit on how many concurrent
565559
backend processes it can start.
@@ -587,7 +581,7 @@
587581
was 64, and changing it required a rebuild after altering the
588582
MaxBackendId constant in include/storage/sinvaladt.h.
589583

590-
3.11) What are the pg_sorttempNNN.NN files in my database directory?
584+
3.10) What are the pg_sorttempNNN.NN files in my database directory?
591585

592586
They are temporary files generated by the query executor. For example,
593587
if a sort needs to be done to satisfy an ORDER BY, and the sort

‎doc/src/FAQ/FAQ.html‎

Lines changed: 16 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -53,8 +53,8 @@ <H2>User Client Questions</H2>
5353
</CENTER>
5454
<Ahref="#2.1">2.1</A>) Are there<SMALL>ODBC</SMALL> drivers for
5555
PostgreSQL?<BR>
56-
<Ahref="#2.2">2.2</A>) What tools are available forhooking
57-
PostgreSQL to Web pages?<BR>
56+
<Ahref="#2.2">2.2</A>) What tools are available foruse PostgreSQL
57+
with Web pages?<BR>
5858
<Ahref="#2.3">2.3</A>) Does PostgreSQL have a graphical user
5959
interface? A report generator? An embedded query language
6060
interface?<BR>
@@ -77,14 +77,12 @@ <H2>Administrative Questions</H2>
7777
accessing my PostgreSQL database?<BR>
7878
<Ahref="#3.6">3.6</A>) Why can't I connect to my database from
7979
another machine?<BR>
80-
<Ahref="#3.7">3.7</A>) All my servers crash under concurrent
81-
table access. Why?<BR>
82-
<Ahref="#3.8">3.8</A>) How do I tune the database engine for
80+
<Ahref="#3.7">3.7</A>) How do I tune the database engine for
8381
better performance?<BR>
84-
<Ahref="#3.9">3.9</A>) What debugging features are available?<BR>
85-
<Ahref="#3.10">3.10</A>) I get<I>"Sorry, too many clients"</I>
82+
<Ahref="#3.8">3.8</A>) What debugging features are available?<BR>
83+
<Ahref="#3.9">3.9</A>) I get<I>"Sorry, too many clients"</I>
8684
when trying to connect. Why?<BR>
87-
<Ahref="#3.11">3.11</A>) What are the<I>pg_sorttempNNN.NN</I>
85+
<Ahref="#3.10">3.10</A>) What are the<I>pg_sorttempNNN.NN</I>
8886
files in my database directory?<BR>
8987

9088

@@ -260,10 +258,6 @@ <H4><A name="1.5">1.5</A>) Where can I get PostgreSQL?</H4>
260258

261259
<H4><Aname="1.6">1.6</A>) Where can I get support?</H4>
262260

263-
<P>There is no support for PostgreSQL from the University of
264-
California, Berkeley. It is maintained through volunteer
265-
effort.</P>
266-
267261
<P>The main mailing list is:<Ahref=
268262
"mailto:pgsql-general@PostgreSQL.org">pgsql-general@PostgreSQL.org</A>.
269263
It is available for discussion of matters pertaining to PostgreSQL.
@@ -316,7 +310,7 @@ <H4><A name="1.6">1.6</A>) Where can I get support?</H4>
316310
<I>#PostgreSQL.</I> I use the unix command<CODE>irc -c
317311
'#PostgreSQL' "$USER" irc.phoenix.net.</CODE></P>
318312

319-
<P>A list of commercialPostgreSQLsupport is available at<Ahref=
313+
<P>A list of commercial support companies is available at<Ahref=
320314
"http://www.postgresql.org/users-lounge/commercial-support.html">http://www.postgresql.org/users-lounge/commercial-support.html</A>.</P>
321315

322316
<H4><Aname="1.7">1.7</A>) What is the latest release?</H4>
@@ -508,8 +502,8 @@ <H4><A name="2.1">2.1</A>) Are there <SMALL>ODBC</SMALL> drivers
508502
"http://www.PostgreSQL.org/docs/programmer/odbc.htm">ODBC chapter
509503
of the Programmer's Guide</A>.</P>
510504

511-
<H4><Aname="2.2">2.2</A>) What tools are available forhooking
512-
PostgreSQLto Web pages?</H4>
505+
<H4><Aname="2.2">2.2</A>) What tools are available forusing
506+
PostgreSQLwith Web pages?</H4>
513507

514508
<P>A nice introduction to Database-backed Web pages can be seen at:
515509
<Ahref="http://www.webtools.com">http://www.webtools.com</A></P>
@@ -620,6 +614,9 @@ <H4><A name="3.5">3.5</A>) How do I prevent other hosts from
620614
modifying the file<I>$PGDATA/pg_hba.conf</I> accordingly. This
621615
will allow TCP/IP connections.</P>
622616

617+
<P>Inoperative semaphores can also cause crashes during heavy
618+
database access.</P>
619+
623620
<H4><Aname="3.6">3.6</A>) Why can't I connect to my database from
624621
another machine?</H4>
625622

@@ -629,13 +626,7 @@ <H4><A name="3.6">3.6</A>) Why can't I connect to my database from
629626
option, and add an appropriate host entry to the file
630627
<I>pgsql/data/pg_hba.conf</I>.</P>
631628

632-
<H4><Aname="3.7">3.7</A>) All my servers crash under concurrent
633-
table access. Why?</H4>
634-
635-
<P>This problem can be caused by a kernel that is not configured to
636-
support semaphores.</P>
637-
638-
<H4><Aname="3.8">3.8</A>) How do I tune the database engine for
629+
<H4><Aname="3.7">3.7</A>) How do I tune the database engine for
639630
better performance?</H4>
640631

641632
<P>Certainly, indices can speed up queries. The
@@ -672,7 +663,7 @@ <H4><A name="3.8">3.8</A>) How do I tune the database engine for
672663
data in tables to match an index. See the<SMALL>CLUSTER</SMALL>
673664
manual page for more details.</P>
674665

675-
<H4><Aname="3.9">3.9</A>) What debugging features are
666+
<H4><Aname="3.8">3.8</A>) What debugging features are
676667
available?</H4>
677668

678669
<P>PostgreSQL has several features that report status information
@@ -728,7 +719,7 @@ <H4><A name="3.9">3.9</A>) What debugging features are
728719
in the<I>pgsql/data/base/dbname</I> directory. The client profile
729720
file will be put in the client's current directory.</P>
730721

731-
<H4><Aname="3.10">3.10</A>) I get 'Sorry, too many clients' when
722+
<H4><Aname="3.9">3.9</A>) I get 'Sorry, too many clients' when
732723
trying to connect. Why?</H4>
733724

734725
<P>You need to increase the<I>postmaster's</I> limit on how many
@@ -763,7 +754,7 @@ <H4><A name="3.10">3.10</A>) I get 'Sorry, too many clients' when
763754
the MaxBackendId constant in
764755
<I>include/storage/sinvaladt.h.</I></P>
765756

766-
<H4><Aname="3.11">3.11</A>) What are the<I>pg_sorttempNNN.NN</I>
757+
<H4><Aname="3.10">3.10</A>) What are the<I>pg_sorttempNNN.NN</I>
767758
files in my database directory?</H4>
768759

769760
<P>They are temporary files generated by the query executor. For
@@ -1303,4 +1294,3 @@ <H4><A name="5.5">5.5</A>) I have changed a source file. Why does
13031294
compiler compute the dependencies automatically.</P>
13041295
</BODY>
13051296
</HTML>
1306-

0 commit comments

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