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

Commit0e010a5

Browse files
committed
Update FAQ's in head and 7.3.X.
1 parent044dca9 commit0e010a5

File tree

6 files changed

+215
-80
lines changed

6 files changed

+215
-80
lines changed

‎configure‎

Lines changed: 155 additions & 32 deletions
Original file line numberDiff line numberDiff line change
@@ -8330,23 +8330,27 @@ fi
83308330
fi
83318331
83328332
iftest"$with_pam" = yes;then
8333-
iftest"${ac_cv_header_security_pam_appl_h+set}" =set;then
8334-
echo"$as_me:$LINENO: checking for security/pam_appl.h">&5
8335-
echo$ECHO_N"checking for security/pam_appl.h...$ECHO_C">&6
8336-
iftest"${ac_cv_header_security_pam_appl_h+set}" =set;then
8333+
8334+
forac_headerin security/pam_appl.h
8335+
do
8336+
as_ac_Header=`echo"ac_cv_header_$ac_header"|$as_tr_sh`
8337+
ifeval"test\"\${$as_ac_Header+set}\" = set";then
8338+
echo"$as_me:$LINENO: checking for$ac_header">&5
8339+
echo$ECHO_N"checking for$ac_header...$ECHO_C">&6
8340+
ifeval"test\"\${$as_ac_Header+set}\" = set";then
83378341
echo$ECHO_N"(cached)$ECHO_C">&6
83388342
fi
8339-
echo"$as_me:$LINENO: result:$ac_cv_header_security_pam_appl_h">&5
8340-
echo"${ECHO_T}$ac_cv_header_security_pam_appl_h">&6
8343+
echo"$as_me:$LINENO: result:`evalecho'${'$as_ac_Header'}'`">&5
8344+
echo"${ECHO_T}`evalecho'${'$as_ac_Header'}'`">&6
83418345
else
83428346
# Is the header compilable?
8343-
echo"$as_me:$LINENO: checkingsecurity/pam_appl.h usability">&5
8344-
echo$ECHO_N"checkingsecurity/pam_appl.h usability...$ECHO_C">&6
8347+
echo"$as_me:$LINENO: checking$ac_header usability">&5
8348+
echo$ECHO_N"checking$ac_header usability...$ECHO_C">&6
83458349
cat>conftest.$ac_ext<<_ACEOF
83468350
#line$LINENO "configure"
83478351
#include "confdefs.h"
83488352
$ac_includes_default
8349-
#include <security/pam_appl.h>
8353+
#include <$ac_header>
83508354
_ACEOF
83518355
rm -f conftest.$ac_objext
83528356
if { (evalecho"$as_me:$LINENO:\"$ac_compile\"")>&5
@@ -8371,12 +8375,12 @@ echo "$as_me:$LINENO: result: $ac_header_compiler" >&5
83718375
echo"${ECHO_T}$ac_header_compiler">&6
83728376
83738377
# Is the header present?
8374-
echo"$as_me:$LINENO: checkingsecurity/pam_appl.h presence">&5
8375-
echo$ECHO_N"checkingsecurity/pam_appl.h presence...$ECHO_C">&6
8378+
echo"$as_me:$LINENO: checking$ac_header presence">&5
8379+
echo$ECHO_N"checking$ac_header presence...$ECHO_C">&6
83768380
cat>conftest.$ac_ext<<_ACEOF
83778381
#line$LINENO "configure"
83788382
#include "confdefs.h"
8379-
#include <security/pam_appl.h>
8383+
#include <$ac_header>
83808384
_ACEOF
83818385
if { (evalecho"$as_me:$LINENO:\"$ac_cpp conftest.$ac_ext\"")>&5
83828386
(eval$ac_cpp conftest.$ac_ext)2>conftest.er1
@@ -8408,37 +8412,156 @@ echo "${ECHO_T}$ac_header_preproc" >&6
84088412
# So? What about this header?
84098413
case$ac_header_compiler:$ac_header_preprocin
84108414
yes:no )
8411-
{echo"$as_me:$LINENO: WARNING:security/pam_appl.h: accepted by the compiler, rejected by the preprocessor!">&5
8412-
echo"$as_me: WARNING:security/pam_appl.h: accepted by the compiler, rejected by the preprocessor!">&2;}
8413-
{echo"$as_me:$LINENO: WARNING:security/pam_appl.h: proceeding with the preprocessor's result">&5
8414-
echo"$as_me: WARNING:security/pam_appl.h: proceeding with the preprocessor's result">&2;};;
8415+
{echo"$as_me:$LINENO: WARNING:$ac_header: accepted by the compiler, rejected by the preprocessor!">&5
8416+
echo"$as_me: WARNING:$ac_header: accepted by the compiler, rejected by the preprocessor!">&2;}
8417+
{echo"$as_me:$LINENO: WARNING:$ac_header: proceeding with the preprocessor's result">&5
8418+
echo"$as_me: WARNING:$ac_header: proceeding with the preprocessor's result">&2;};;
84158419
no:yes )
8416-
{echo"$as_me:$LINENO: WARNING:security/pam_appl.h: present but cannot be compiled">&5
8417-
echo"$as_me: WARNING:security/pam_appl.h: present but cannot be compiled">&2;}
8418-
{echo"$as_me:$LINENO: WARNING:security/pam_appl.h: check for missing prerequisite headers?">&5
8419-
echo"$as_me: WARNING:security/pam_appl.h: check for missing prerequisite headers?">&2;}
8420-
{echo"$as_me:$LINENO: WARNING:security/pam_appl.h: proceeding with the preprocessor's result">&5
8421-
echo"$as_me: WARNING:security/pam_appl.h: proceeding with the preprocessor's result">&2;};;
8420+
{echo"$as_me:$LINENO: WARNING:$ac_header: present but cannot be compiled">&5
8421+
echo"$as_me: WARNING:$ac_header: present but cannot be compiled">&2;}
8422+
{echo"$as_me:$LINENO: WARNING:$ac_header: check for missing prerequisite headers?">&5
8423+
echo"$as_me: WARNING:$ac_header: check for missing prerequisite headers?">&2;}
8424+
{echo"$as_me:$LINENO: WARNING:$ac_header: proceeding with the preprocessor's result">&5
8425+
echo"$as_me: WARNING:$ac_header: proceeding with the preprocessor's result">&2;};;
84228426
esac
8423-
echo"$as_me:$LINENO: checking forsecurity/pam_appl.h">&5
8424-
echo$ECHO_N"checking forsecurity/pam_appl.h...$ECHO_C">&6
8425-
iftest"${ac_cv_header_security_pam_appl_h+set}" =set;then
8427+
echo"$as_me:$LINENO: checking for$ac_header">&5
8428+
echo$ECHO_N"checking for$ac_header...$ECHO_C">&6
8429+
ifeval"test\"\${$as_ac_Header+set}\" = set";then
84268430
echo$ECHO_N"(cached)$ECHO_C">&6
84278431
else
8428-
ac_cv_header_security_pam_appl_h=$ac_header_preproc
8432+
eval"$as_ac_Header=$ac_header_preproc"
84298433
fi
8430-
echo"$as_me:$LINENO: result:$ac_cv_header_security_pam_appl_h">&5
8431-
echo"${ECHO_T}$ac_cv_header_security_pam_appl_h">&6
8434+
echo"$as_me:$LINENO: result:`evalecho'${'$as_ac_Header'}'`">&5
8435+
echo"${ECHO_T}`evalecho'${'$as_ac_Header'}'`">&6
84328436
84338437
fi
8434-
iftest$ac_cv_header_security_pam_appl_h = yes;then
8435-
:
8438+
iftest`evalecho'${'$as_ac_Header'}'` = yes;then
8439+
cat>>confdefs.h<<_ACEOF
8440+
#define`echo"HAVE_$ac_header"|$as_tr_cpp` 1
8441+
_ACEOF
8442+
8443+
else
8444+
8445+
forac_headerin pam/pam_appl.h
8446+
do
8447+
as_ac_Header=`echo"ac_cv_header_$ac_header"|$as_tr_sh`
8448+
ifeval"test\"\${$as_ac_Header+set}\" = set";then
8449+
echo"$as_me:$LINENO: checking for$ac_header">&5
8450+
echo$ECHO_N"checking for$ac_header...$ECHO_C">&6
8451+
ifeval"test\"\${$as_ac_Header+set}\" = set";then
8452+
echo$ECHO_N"(cached)$ECHO_C">&6
8453+
fi
8454+
echo"$as_me:$LINENO: result:`evalecho'${'$as_ac_Header'}'`">&5
8455+
echo"${ECHO_T}`evalecho'${'$as_ac_Header'}'`">&6
8456+
else
8457+
# Is the header compilable?
8458+
echo"$as_me:$LINENO: checking$ac_header usability">&5
8459+
echo$ECHO_N"checking$ac_header usability...$ECHO_C">&6
8460+
cat>conftest.$ac_ext<<_ACEOF
8461+
#line$LINENO "configure"
8462+
#include "confdefs.h"
8463+
$ac_includes_default
8464+
#include <$ac_header>
8465+
_ACEOF
8466+
rm -f conftest.$ac_objext
8467+
if { (evalecho"$as_me:$LINENO:\"$ac_compile\"")>&5
8468+
(eval$ac_compile)2>&5
8469+
ac_status=$?
8470+
echo"$as_me:$LINENO:\$? =$ac_status">&5
8471+
(exit$ac_status); }&&
8472+
{ ac_try='test -s conftest.$ac_objext'
8473+
{ (evalecho"$as_me:$LINENO:\"$ac_try\"")>&5
8474+
(eval$ac_try)2>&5
8475+
ac_status=$?
8476+
echo"$as_me:$LINENO:\$? =$ac_status">&5
8477+
(exit$ac_status); }; };then
8478+
ac_header_compiler=yes
8479+
else
8480+
echo"$as_me: failed program was:">&5
8481+
cat conftest.$ac_ext>&5
8482+
ac_header_compiler=no
8483+
fi
8484+
rm -f conftest.$ac_objext conftest.$ac_ext
8485+
echo"$as_me:$LINENO: result:$ac_header_compiler">&5
8486+
echo"${ECHO_T}$ac_header_compiler">&6
8487+
8488+
# Is the header present?
8489+
echo"$as_me:$LINENO: checking$ac_header presence">&5
8490+
echo$ECHO_N"checking$ac_header presence...$ECHO_C">&6
8491+
cat>conftest.$ac_ext<<_ACEOF
8492+
#line$LINENO "configure"
8493+
#include "confdefs.h"
8494+
#include <$ac_header>
8495+
_ACEOF
8496+
if { (evalecho"$as_me:$LINENO:\"$ac_cpp conftest.$ac_ext\"")>&5
8497+
(eval$ac_cpp conftest.$ac_ext)2>conftest.er1
8498+
ac_status=$?
8499+
egrep -v'^ *\+' conftest.er1>conftest.err
8500+
rm -f conftest.er1
8501+
cat conftest.err>&5
8502+
echo"$as_me:$LINENO:\$? =$ac_status">&5
8503+
(exit$ac_status); }>/dev/null;then
8504+
iftest -s conftest.err;then
8505+
ac_cpp_err=$ac_c_preproc_warn_flag
8506+
else
8507+
ac_cpp_err=
8508+
fi
8509+
else
8510+
ac_cpp_err=yes
8511+
fi
8512+
iftest -z"$ac_cpp_err";then
8513+
ac_header_preproc=yes
8514+
else
8515+
echo"$as_me: failed program was:">&5
8516+
cat conftest.$ac_ext>&5
8517+
ac_header_preproc=no
8518+
fi
8519+
rm -f conftest.err conftest.$ac_ext
8520+
echo"$as_me:$LINENO: result:$ac_header_preproc">&5
8521+
echo"${ECHO_T}$ac_header_preproc">&6
8522+
8523+
# So? What about this header?
8524+
case$ac_header_compiler:$ac_header_preprocin
8525+
yes:no )
8526+
{echo"$as_me:$LINENO: WARNING:$ac_header: accepted by the compiler, rejected by the preprocessor!">&5
8527+
echo"$as_me: WARNING:$ac_header: accepted by the compiler, rejected by the preprocessor!">&2;}
8528+
{echo"$as_me:$LINENO: WARNING:$ac_header: proceeding with the preprocessor's result">&5
8529+
echo"$as_me: WARNING:$ac_header: proceeding with the preprocessor's result">&2;};;
8530+
no:yes )
8531+
{echo"$as_me:$LINENO: WARNING:$ac_header: present but cannot be compiled">&5
8532+
echo"$as_me: WARNING:$ac_header: present but cannot be compiled">&2;}
8533+
{echo"$as_me:$LINENO: WARNING:$ac_header: check for missing prerequisite headers?">&5
8534+
echo"$as_me: WARNING:$ac_header: check for missing prerequisite headers?">&2;}
8535+
{echo"$as_me:$LINENO: WARNING:$ac_header: proceeding with the preprocessor's result">&5
8536+
echo"$as_me: WARNING:$ac_header: proceeding with the preprocessor's result">&2;};;
8537+
esac
8538+
echo"$as_me:$LINENO: checking for$ac_header">&5
8539+
echo$ECHO_N"checking for$ac_header...$ECHO_C">&6
8540+
ifeval"test\"\${$as_ac_Header+set}\" = set";then
8541+
echo$ECHO_N"(cached)$ECHO_C">&6
84368542
else
8437-
{ {echo"$as_me:$LINENO: error: header file <security/pam_appl.h> is required for PAM">&5
8438-
echo"$as_me: error: header file <security/pam_appl.h> is required for PAM">&2;}
8543+
eval"$as_ac_Header=$ac_header_preproc"
8544+
fi
8545+
echo"$as_me:$LINENO: result:`evalecho'${'$as_ac_Header'}'`">&5
8546+
echo"${ECHO_T}`evalecho'${'$as_ac_Header'}'`">&6
8547+
8548+
fi
8549+
iftest`evalecho'${'$as_ac_Header'}'` = yes;then
8550+
cat>>confdefs.h<<_ACEOF
8551+
#define`echo"HAVE_$ac_header"|$as_tr_cpp` 1
8552+
_ACEOF
8553+
8554+
else
8555+
{ {echo"$as_me:$LINENO: error: header file <security/pam_appl.h> or <pam/pam_appl.h> is required for PAM.">&5
8556+
echo"$as_me: error: header file <security/pam_appl.h> or <pam/pam_appl.h> is required for PAM.">&2;}
84398557
{ (exit 1);exit 1; }; }
84408558
fi
84418559
8560+
done
8561+
8562+
fi
8563+
8564+
done
84428565
84438566
fi
84448567

‎configure.in‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
dnl Process this file with autoconf to produce a configure script.
2-
dnl $Header: /cvsroot/pgsql/configure.in,v 1.235 2003/02/11 21:05:35 petere Exp $
2+
dnl $Header: /cvsroot/pgsql/configure.in,v 1.236 2003/02/14 14:05:00 momjian Exp $
33
dnl
44
dnl Developers, please strive to achieve this order:
55
dnl
@@ -724,7 +724,9 @@ if test "$with_openssl" = yes ; then
724724
fi
725725

726726
if test "$with_pam" = yes ; then
727-
AC_CHECK_HEADER(security/pam_appl.h, [], [AC_MSG_ERROR([header file <security/pam_appl.h> is required for PAM])])
727+
AC_CHECK_HEADERS(security/pam_appl.h, [],
728+
[AC_CHECK_HEADERS(pam/pam_appl.h, [],
729+
[AC_MSG_ERROR([header file <security/pam_appl.h> or <pam/pam_appl.h> is required for PAM.])])])
728730
fi
729731

730732

‎doc/FAQ_russian‎

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

22
Otvety na chasto zadavaemye voprosy po PostgreSQL
33

4-
Data poslednego obnovleniya: CHetverg5 Dekabrya 00:47:26 EDT 2002
4+
Data poslednego obnovleniya: CHetverg13 Fevralya 23:07:35 EDT 2002
55

66
Anglijskij variant soprovozhdaet: Bryus Mom'yan (Bruce Momjian)
77
(pgman@candle.pha.pa.us)
@@ -275,7 +275,7 @@
275275

276276
1.7) Kakaya poslednyaya versiya?
277277

278-
Poslednij vypusk PostgreSQL - `eto versiya 7.2.3.
278+
Poslednij vypusk PostgreSQL - `eto versiya 7.3.1.
279279

280280
My planiruem vypuskat' novye versii kazhdye chetyre mesyaca.
281281

@@ -469,17 +469,13 @@
469469
2.3) Est' li u PostgreSQL graficheskij interfejs pol'zovatelya?
470470

471471
Da, suschestvuet neskol'ko graficheskih interfejsov dlya PostgreSQL.
472-
`Eto PgAccess (http://www.pgaccess.com, PgAdmin II
472+
`Eto PgAccess (http://www.pgaccess.org, PgAdmin II
473473
(http://www.pgadmin.org, Win32-only), RHDB Admin (
474474
http://sources.redhat.com/rhdb/) i Rekall (
475475
http://www.thekompany.com/products/rekall/, kommercheskij). Takzhe
476476
est' PHPPgAdmin ( http://phppgadmin.sourceforge.net/) - interfejs k
477477
PostgreSQL, osnovannyj na Web.
478478

479-
U nas est' prekrasnyj goraficheskij interfejs, nazyvaemyj PgAccess,
480-
kotoryj takzhe mozhno ispol'zovat' kak generator otchetov. Ego
481-
stranichka http://www.pgaccess.org/
482-
483479
2.4) Kakie yazyki mogut vzaimodejstvovat' s PostgreSQL?
484480

485481
Kakie-libo interfejsy dlya PostgreSQL suschestvuyut dlya bol'shinstva
@@ -669,10 +665,6 @@
669665
sozdaniya ogranicheniya na kolichestvo backend processov kak raz i
670666
sostoit v tom, chtoby vashej sisteme hvatilo resursov.
671667

672-
V PostgreSQL do versii 6.5, maksimal'noe kolichestvo backend processov
673-
bylo 64, i izmenenie `etogo kolichestva trebovalo perekompilyacii
674-
posle ustanovki konstanty MaxBackendId v include/storage/sinvaladt.h.
675-
676668
3.9) CHto nahoditsya v kataloge pgsql_tmp?
677669

678670
Dannyj katalog soderzhit vremennye fajly, generiruemye obrabotchikom
@@ -853,6 +845,11 @@ pa
853845
ORDER BY col [ DESC ]
854846
LIMIT 1;
855847

848+
Esli vam kazhetsya, chto optimizator nekorretno vybiraet
849+
posledovatel'nyj perebor, ispol'zujte SET enable_seqscan TO 'off' i
850+
zapustite testy, chtoby uvidet', ne stalo-li skanirovanie indeksov
851+
bystree.
852+
856853
Kogda ispol'zuyutsya operacii s shablonami, naprimer LIKE ili ~,
857854
indeksy mogut byt' ispol'zovany v sleduyuschih sluchayah:
858855
* Nachalo stroki poiska dolzhno sovpadat' s nachalom iskomoj stroki,
@@ -929,12 +926,12 @@ pa
929926

930927
Tip Vnutrennee imya Zamechaniya
931928
--------------------------------------------------
932-
"char" char 1 simvol
933-
CHAR(n) bpchar zapolnyaetsya pustotoj do fiksirovannoj dliny
934929
VARCHAR(n) varchar razmer zadaet maksimal'nuyu dlinu, net zapolnen
935930
iya
931+
CHAR(n) bpchar zapolnyaetsya pustotoj do fiksirovannoj dliny
936932
TEXT text net zadavaemogo verhnego ogranicheniya ili dlin
937933
y
934+
"char" char odin simvol
938935
BYTEA bytea massiv bajt peremennoj dliny (mozhno ispol'zova
939936
t' null-bajt bez opaski)
940937

@@ -948,15 +945,17 @@ t' null-bajt bez opaski)
948945
szhatiyu ili mogut byt' sohraneny ne v strokom vide cherez TOAST, tak
949946
chto zanimaemoe diskovoe prostranstvo mozhet takzhe byt' i men'she,
950947
chem ozhidalos'.
948+
VARCHAR(n) - `eto luchshee reshenie, kogda nuzhno hranit' stroki
949+
peremennoj dliny, ne prevyshayuschie opredelennogo razmera. TEXT -
950+
`eto luchshee reshenie dlya strok neogranichennoj dliny, s maksimal'no
951+
dopustimoj dlinoj v 1 gigabajt.
951952

952953
CHAR(n) - `eto luchshee reshenie dlya hraneniya strok, kotorye obychno
953-
imeyut odinakovuyu dlinu. VARCHAR(n) - `eto luchshee reshenie, kogda
954-
nuzhno hranit' stroki peremennoj dliny, no ne prevyshayuschie
955-
opredelennogo razmera. TEXT - `eto luchshee reshenie dlya strok
956-
neogranichennoj dliny, s maksimal'no dopustimoj dlinoj v 1 gigabajt.
957-
BYTEA dlya hraneniya binarnyh dannyh, znacheniya kotoryh mogut
958-
vklyuchat' NULL bajty. `Eti tipy imeyut shodnye harakteristiki
959-
proizvoditel'nosti.
954+
imeyut odinakovuyu dlinu. CHAR(n) zapolnyaetsya pustotoj do zadannoj
955+
dliny, v to vremya kak VARCHAR(n) hranit tol'ko simvoly, iz kotoryh
956+
sostoit stroka. BYTEA ispol'zuetsya dlya hraneniya binarnyh dannyh,
957+
znacheniya kotoryh mogut vklyuchat' NULL bajty. `Eti tipy imeyut
958+
shodnye harakteristiki proizvoditel'nosti.
960959

961960
4.15.1) Kak mne sozdat' pole serial/s-avto-uvelicheniem?
962961

@@ -1146,8 +1145,8 @@ CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP );
11461145
WHERE EXISTS (SELECT subcol FROM subtab WHERE subcol = col);
11471146

11481147
CHtoby takaya konstrukciya rabotala bystro, kolonka subcol dolzhna
1149-
byt' proindeksirovana.My nadeemsya ubrat' `eto ogranichenie v
1150-
buduschem vypuske.
1148+
byt' proindeksirovana.`Eta problema proizvoditel'nosti budet
1149+
ustranena v versii 7.4.
11511150

11521151
4.23) Kak mne vypolnit' vneshnee svyazyvanie?
11531152

0 commit comments

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