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

Commite136a49

Browse files
committed
Remove FAQ items about IPC errors. We now report the help description
right in the failure. We can always re-add it if required.
1 parent93e1795 commite136a49

File tree

2 files changed

+30
-118
lines changed

2 files changed

+30
-118
lines changed

‎doc/FAQ‎

Lines changed: 15 additions & 57 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: Sat Jan 29 22:51:43 EST 2005
4+
Last updated: Sat Jan 29 22:59:12 EST 2005
55

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

@@ -38,20 +38,14 @@
3838

3939
3.1) How do I install PostgreSQL somewhere other than
4040
/usr/local/pgsql?
41-
3.2) When I start postmaster, I get a Bad System Call or core dumped
42-
message. Why?
43-
3.3) When I try to start postmaster, I get IpcMemoryCreate errors.
44-
Why?
45-
3.4) When I try to start postmaster, I get IpcSemaphoreCreate errors.
46-
Why?
47-
3.5) How do I control connections from other hosts?
48-
3.6) How do I tune the database engine for better performance?
49-
3.7) What debugging features are available?
50-
3.8) Why do I get "Sorry, too many clients" when trying to connect?
51-
3.9) What is in the pgsql_tmp directory?
52-
3.10) Why do I need to do a dump and restore to upgrade PostgreSQL
41+
3.2) How do I control connections from other hosts?
42+
3.3) How do I tune the database engine for better performance?
43+
3.4) What debugging features are available?
44+
3.5) Why do I get "Sorry, too many clients" when trying to connect?
45+
3.6) What is in the pgsql_tmp directory?
46+
3.7) Why do I need to do a dump and restore to upgrade PostgreSQL
5347
releases?
54-
3.11) What computer hardware should I use?
48+
3.8) What computer hardware should I use?
5549

5650
Operational Questions
5751

@@ -419,51 +413,15 @@
419413

420414
Specify the --prefix option when running configure.
421415

422-
3.2) When I start postmaster, I get a Bad System Call or core dumped
423-
message. Why?
424-
425-
It could be a variety of problems, but first check to see that you
426-
have System V extensions installed in your kernel. PostgreSQL requires
427-
kernel support for shared memory and semaphores.
428-
429-
3.3) When I try to start postmaster, I get IpcMemoryCreate errors. Why?
430-
431-
You either do not have shared memory configured properly in your
432-
kernel or you need to enlarge the shared memory available in the
433-
kernel. The exact amount you need depends on your architecture and how
434-
many buffers and backend processes you configure for postmaster. For
435-
most systems, with default numbers of buffers and processes, you need
436-
a minimum of ~1 MB. See the PostgreSQL Administrator's Guide/Server
437-
Run-time Environment/Managing Kernel Resources section for more
438-
detailed information about shared memory and semaphores.
439-
440-
3.4) When I try to start postmaster, I get IpcSemaphoreCreate errors. Why?
441-
442-
If the error message is IpcSemaphoreCreate: semget failed (No space
443-
left on device) then your kernel is not configured with enough
444-
semaphores. Postgres needs one semaphore per potential backend
445-
process. A temporary solution is to start postmaster with a smaller
446-
limit on the number of backend processes. Use -N with a parameter less
447-
than the default of 32. A more permanent solution is to increase your
448-
kernel's SEMMNS and SEMMNI parameters.
449-
450-
Inoperative semaphores can also cause crashes during heavy database
451-
access.
452-
453-
If the error message is something else, you might not have semaphore
454-
support configured in your kernel at all. See the PostgreSQL
455-
Administrator's Guide for more detailed information about shared
456-
memory and semaphores.
457-
458-
3.5) How do I control connections from other hosts?
416+
3.2) How do I control connections from other hosts?
459417

460418
By default, PostgreSQL only allows connections from the local machine
461419
using Unix domain sockets or TCP/IP connections. Other machines will
462420
not be able to connect unless you modify listen_addresses in the
463421
postgresql.conf and enable host-based authentication by modifying the
464422
file $PGDATA/pg_hba.conf accordingly.
465423

466-
3.6) How do I tune the database engine for better performance?
424+
3.3) How do I tune the database engine for better performance?
467425

468426
Certainly, indexes can speed up queries. The EXPLAIN ANALYZE command
469427
allows you to see how PostgreSQL is interpreting your query, and which
@@ -495,7 +453,7 @@
495453
You can also use the CLUSTER command to group data in tables to match
496454
an index. See the CLUSTER manual page for more details.
497455

498-
3.7) What debugging features are available?
456+
3.4) What debugging features are available?
499457

500458
PostgreSQL has several features that report status information that
501459
can be valuable for debugging purposes.
@@ -550,7 +508,7 @@ log_*
550508
in the client's current directory. Linux requires a compile with
551509
-DLINUX_PROFILE for proper profiling.
552510

553-
3.8) Why do I get "Sorry, too many clients" when trying to connect?
511+
3.5) Why do I get "Sorry, too many clients" when trying to connect?
554512

555513
You need to increase postmaster's limit on how many concurrent backend
556514
processes it can start.
@@ -570,7 +528,7 @@ log_*
570528
that PostgreSQL has a limit on the number of allowed backend processes
571529
is so your system won't run out of resources.
572530

573-
3.9) What is in the pgsql_tmp directory?
531+
3.6) What is in the pgsql_tmp directory?
574532

575533
This directory contains temporary files generated by the query
576534
executor. For example, if a sort needs to be done to satisfy an ORDER
@@ -581,7 +539,7 @@ log_*
581539
remain if a backend crashes during a sort. A stop and restart of the
582540
postmaster will remove files from those directories.
583541

584-
3.10) Why do I need to do a dump and restore to upgrade between major
542+
3.7) Why do I need to do a dump and restore to upgrade between major
585543
PostgreSQL releases?
586544

587545
The PostgreSQL team makes only small changes between minor releases,
@@ -596,7 +554,7 @@ log_*
596554
script can be used to upgrade without a dump/restore. The release
597555
notes mention whether pg_upgrade is available for the release.
598556

599-
3.11) What computer hardware should I use?
557+
3.8) What computer hardware should I use?
600558

601559
Because PC hardware is mostly compatible, people tend to believe that
602560
all PC hardware is of equal quality. It is not. ECC RAM, SCSI, and

‎doc/src/FAQ/FAQ.html‎

Lines changed: 15 additions & 61 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated: Sat Jan 29 22:51:43 EST 2005</P>
13+
<P>Last updated: Sat Jan 29 22:59:12 EST 2005</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
@@ -56,24 +56,18 @@ <H2 align="center">User Client Questions</H2>
5656
<H2align="center">Administrative Questions</H2>
5757
<Ahref="#3.1">3.1</A>) How do I install PostgreSQL somewhere other
5858
than<I>/usr/local/pgsql</I>?<BR>
59-
<Ahref="#3.2">3.2</A>) When I start<I>postmaster</I>, I get a
60-
<I>Bad System Call</I> or core dumped message. Why?<BR>
61-
<Ahref="#3.3">3.3</A>) When I try to start<I>postmaster</I>, I
62-
get<I>IpcMemoryCreate</I> errors. Why?<BR>
63-
<Ahref="#3.4">3.4</A>) When I try to start<I>postmaster</I>, I
64-
get<I>IpcSemaphoreCreate</I> errors. Why?<BR>
65-
<Ahref="#3.5">3.5</A>) How do I control connections from other
59+
<Ahref="#3.2">3.2</A>) How do I control connections from other
6660
hosts?<BR>
67-
<Ahref="#3.6">3.6</A>) How do I tune the database engine for
61+
<Ahref="#3.3">3.3</A>) How do I tune the database engine for
6862
better performance?<BR>
69-
<Ahref="#3.7">3.7</A>) What debugging features are available?<BR>
70-
<Ahref="#3.8">3.8</A>) Why do I get<I>"Sorry, too many
63+
<Ahref="#3.4">3.4</A>) What debugging features are available?<BR>
64+
<Ahref="#3.5">3.5</A>) Why do I get<I>"Sorry, too many
7165
clients"</I> when trying to connect?<BR>
72-
<Ahref="#3.9">3.9</A>) What is in the<I>pgsql_tmp</I>
66+
<Ahref="#3.6">3.6</A>) What is in the<I>pgsql_tmp</I>
7367
directory?<BR>
74-
<Ahref="#3.10">3.10</A>) Why do I need to do a dump and restore
68+
<Ahref="#3.7">3.7</A>) Why do I need to do a dump and restore
7569
to upgrade PostgreSQL releases?<BR>
76-
<Ahref="#3.11">3.11</A>) What computer hardware should I use?<BR>
70+
<Ahref="#3.8">3.8</A>) What computer hardware should I use?<BR>
7771

7872

7973
<H2align="center">Operational Questions</H2>
@@ -544,47 +538,7 @@ <H4><A name="3.1">3.1</A>) How do I install PostgreSQL somewhere
544538
<P>Specify the<I>--prefix</I> option when running
545539
<I>configure</I>.</P>
546540

547-
<H4><Aname="3.2">3.2</A>) When I start<I>postmaster</I>, I get a
548-
<I>Bad System Call</I> or core dumped message. Why?</H4>
549-
550-
<P>It could be a variety of problems, but first check to see that
551-
you have System V extensions installed in your kernel. PostgreSQL
552-
requires kernel support for shared memory and semaphores.</P>
553-
554-
<H4><Aname="3.3">3.3</A>) When I try to start<I>postmaster</I>, I
555-
get<I>IpcMemoryCreate</I> errors. Why?</H4>
556-
557-
<P>You either do not have shared memory configured properly in your
558-
kernel or you need to enlarge the shared memory available in the
559-
kernel. The exact amount you need depends on your architecture and
560-
how many buffers and backend processes you configure for
561-
<I>postmaster</I>. For most systems, with default numbers of
562-
buffers and processes, you need a minimum of ~1 MB. See the<A
563-
href="http://www.postgresql.org/docs/current/static/kernel-resources.html">PostgreSQL
564-
Administrator's Guide/Server Run-time Environment/Managing Kernel Resources</A>
565-
section for more detailed information about shared memory and semaphores.</P>
566-
567-
<H4><Aname="3.4">3.4</A>) When I try to start<I>postmaster</I>, I
568-
get<I>IpcSemaphoreCreate</I> errors. Why?</H4>
569-
570-
<P>If the error message is<I>IpcSemaphoreCreate: semget failed (No
571-
space left on device)</I> then your kernel is not configured with
572-
enough semaphores. Postgres needs one semaphore per potential
573-
backend process. A temporary solution is to start<I>postmaster</I>
574-
with a smaller limit on the number of backend processes. Use
575-
<I>-N</I> with a parameter less than the default of 32. A more
576-
permanent solution is to increase your kernel's
577-
<SMALL>SEMMNS</SMALL> and<SMALL>SEMMNI</SMALL> parameters.</P>
578-
579-
<P>Inoperative semaphores can also cause crashes during heavy
580-
database access.</P>
581-
582-
<P>If the error message is something else, you might not have
583-
semaphore support configured in your kernel at all. See the
584-
PostgreSQL Administrator's Guide for more detailed information
585-
about shared memory and semaphores.</P>
586-
587-
<H4><Aname="3.5">3.5</A>) How do I control connections from other
541+
<H4><Aname="3.2">3.2</A>) How do I control connections from other
588542
hosts?</H4>
589543

590544
<P>By default, PostgreSQL only allows connections from the local
@@ -594,7 +548,7 @@ <H4><A name="3.5">3.5</A>) How do I control connections from other
594548
host-based authentication by modifying the file
595549
<I>$PGDATA/pg_hba.conf</I> accordingly.</P>
596550

597-
<H4><Aname="3.6">3.6</A>) How do I tune the database engine for
551+
<H4><Aname="3.3">3.3</A>) How do I tune the database engine for
598552
better performance?</H4>
599553

600554
<P>Certainly, indexes can speed up queries. The
@@ -633,7 +587,7 @@ <H4><A name="3.6">3.6</A>) How do I tune the database engine for
633587
data in tables to match an index. See the<SMALL>CLUSTER</SMALL>
634588
manual page for more details.</P>
635589

636-
<H4><Aname="3.7">3.7</A>) What debugging features are
590+
<H4><Aname="3.4">3.4</A>) What debugging features are
637591
available?</H4>
638592

639593
<P>PostgreSQL has several features that report status information
@@ -691,7 +645,7 @@ <H4><A name="3.7">3.7</A>) What debugging features are
691645
file will be put in the client's current directory. Linux requires
692646
a compile with<I>-DLINUX_PROFILE</I> for proper profiling.</P>
693647

694-
<H4><Aname="3.8">3.8</A>) Why do I get<I>"Sorry, too many
648+
<H4><Aname="3.5">3.5</A>) Why do I get<I>"Sorry, too many
695649
clients"</I> when trying to connect?</H4>
696650

697651
<P>You need to increase<I>postmaster</I>'s limit on how many
@@ -716,7 +670,7 @@ <H4><A name="3.8">3.8</A>) Why do I get <I>"Sorry, too many
716670
the number of allowed backend processes is so your system won't run
717671
out of resources.</P>
718672

719-
<H4><Aname="3.9">3.9</A>) What is in the<I>pgsql_tmp</I> directory?</H4>
673+
<H4><Aname="3.6">3.6</A>) What is in the<I>pgsql_tmp</I> directory?</H4>
720674

721675
<P>This directory contains temporary files generated by the query
722676
executor. For example, if a sort needs to be done to satisfy an
@@ -728,7 +682,7 @@ <H4><A name="3.9">3.9</A>) What is in the <I>pgsql_tmp</I> directory?</H4>
728682
remain if a backend crashes during a sort. A stop and restart of the
729683
<I>postmaster</I> will remove files from those directories.</P>
730684

731-
<H4><Aname="3.10">3.10</A>) Why do I need to do a dump and restore
685+
<H4><Aname="3.7">3.7</A>) Why do I need to do a dump and restore
732686
to upgrade between major PostgreSQL releases?</H4>
733687

734688
<P>The PostgreSQL team makes only small changes between minor releases,
@@ -744,7 +698,7 @@ <H4><A name="3.10">3.10</A>) Why do I need to do a dump and restore
744698
The release notes mention whether<I>pg_upgrade</I> is available for the
745699
release.</P>
746700

747-
<H4><Aname="3.11">3.11</A>) What computer hardware should I use?</H4>
701+
<H4><Aname="3.8">3.8</A>) What computer hardware should I use?</H4>
748702

749703
<P>Because PC hardware is mostly compatible, people tend to believe that
750704
all PC hardware is of equal quality. It is not. ECC RAM, SCSI, and

0 commit comments

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