Исходники "Истории о PostgreSQL"

Добрый день

С ноября 2006 по апрель 2007 в журнале Linux Format печатался цикл статей
о свободной базе данных PostgreSQL. Основной целью цикла была
популяризация PostgreSQL как надёжного и доступного хранилища информации.

Выкладываю исходники статей под лицензией CC-BY-SA. При необходимости по
запросу сменю лицензию любую другую, но тоже свободную.

Если кому-нибудь этот текст окажется полезен при написании книг/статей
буду признателен за информацию об этом. Если нужно, то могу выступить и в
роли соавтора.

Всё здесь: http://www.inp.nsk.su/~baldin/PostgreSQL/

С уважением
Евгений

P.S. Текст был написан в основном летом 2006 года, поэтому многое с тех
пор изменилось.
>From pgsql-ru-general-owner(at)postgresql(dot)org Tue Feb 19 13:14:32 2008
Received: from localhost (unknown [200.46.204.184])
by postgresql.org (Postfix) with ESMTP id E6E732E0030
for <pgsql-ru-general-postgresql(dot)org(at)postgresql(dot)org>; Tue, 19 Feb 2008 13:14:31 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
with ESMTP id 67161-01 for <pgsql-ru-general-postgresql(dot)org(at)postgresql(dot)org>;
Tue, 19 Feb 2008 13:14:22 -0400 (AST)
Received: from hermes.hw.ru (hermes.hw.ru [80.68.240.91])
by postgresql.org (Postfix) with ESMTP id 49F5E2E003B
for <pgsql-ru-general(at)postgresql(dot)org>; Tue, 19 Feb 2008 13:14:22 -0400 (AST)
Received: from ws-80-68-253-169.rbc.ru (account dvetchinkin(at)rbc(dot)ru [80.68.253.169] verified)
by hermes.hw.ru (CommuniGate Pro SMTP 5.0.14)
with ESMTPA id 221043499 for pgsql-ru-general(at)postgresql(dot)org; Tue, 19 Feb 2008 20:13:11 +0300
Message-ID: <47BB0E6B(dot)4040000(at)rbc(dot)ru>
Date: Tue, 19 Feb 2008 20:14:19 +0300
From: Vetchinkin Dmitry <dvetchinkin(at)rbc(dot)ru>
Organization: RBC
User-Agent: Thunderbird 2.0.0.9 (X11/20071115)
MIME-Version: 1.0
To: pgsql-ru-general(at)postgresql(dot)org
Subject: =?KOI8-R?Q?=EF=C7=D2=CF=CD=CE=C1=D1_=D2=C1=DA=CE=C9=C3=C1_=D0?=
=?KOI8-R?Q?=CF_=D7=D2=C5=CD=C5=CE=C9_=CD=C5=D6=C4=D5_FETCH=27=C5=CD?=
=?KOI8-R?Q?_=C9=DA_=CB=D5=D2=D3=CF=D2=C1_=C9_=D7=D9=D0=CF=CC=CE=C5?=
=?KOI8-R?Q?=CE=C9=C5=CD_select=27a?=
Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms030506040901050904020802"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.796 tagged_above=0 required=5
tests=MIME_BASE64_TEXT=2.796
X-Spam-Level: **
X-Archive-Number: 200802/8
X-Sequence-Number: 784

This is a cryptographically signed message in MIME format.

--------------ms030506040901050904020802
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: base64

ICAgICAgICAgICAgIOTPwtLPxSDX0sXN0SDT1dTPyyEKCiAgICDw0skg0sHa0sHCz9TLxSDT
1M/My87VzMnT2CDTINTBy8/KIMnO1MXSxdPOz8ogz9PPwsXOzs/T1NjALi4uCuXT1NggxtXO
y8PJ0SDXz9rX0sHdwcDdwdEgcmVmY3Vyc29yIM/Ezs/HzyBzZWxlY3QnYS4KCiAgICDvws7B
0tXWyczJIM/EztUgyc7UxdLF087VwCDawcvPzs/NxdLOz9PU2C4uLiDl08zJLCDEz9DV09TJ
zSwg0NLP09TPIArX2dDPzM7R1Nggc2VsZWN0LCDUzyDPwt3FxSDX0sXN0SDX2dDPzM7FzsnR
IMLVxMXUINDP0tHEy8EgMzAwbXMuIOXTzMkgCtfZ0M/MzsnU2CDUz9TWxSBzZWxlY3Qg0yDU
xc3JINbFINDB0sHNxdTSwc3JIN7F0sXaIMbVzsvDycAgySDQz9DZ1MHU2NPRIArQz8zV3snU
2CDSxdrVzNjUwdQg0yDQz83P3djAIEZFVENIIEFMTCBGUk9NICI8dW5uYW1lZCBwb3J0YWwg
MT4iLCDUzyAK19LFzdEg19nQz8zOxc7J0Swg2sEgy8/Uz9LPxSDN2SDQz8zV3snNINfTxSDE
wc7O2cUsIMLVxMXUINPJzNjOzyAK0sHazMnewdTY09EuICgg9yDOwdvFzSDTzNXewcUgz87P
IMTPyM/EydQgxM8gMTFzKS4g8NLJ3sXNIMTMydTFzNjOz9PU2CAKRkVUQ0gnYSDQz97UySDQ
0tHNzyDQ0s/Qz9LDyc/OwczYzs8gy8/Myd7F09TX1SDX2dTB08vJ18HFzdnIINrB0MnTxcou
CgogICAg8M/E08vB1snUxSwg0MzaLCDc1M8gz9PPwsXOzs/T1NggUG9zdGdyZXMnYSDJzMkg
zsHbySDL0snX2cUg0tXLyT8g4SAKxdPMySDX1M/Sz8UsINTPINDPxNPLwdbJ1MUsINDM2iwg
1yDLwcvVwCDT1M/Sz87VINPUz8nUINLZ1NguLi4KCi0tIAoK+sHSwc7FxSDCzMHHz8TB0sXO
LAr3xdTeyc7Lyc4g5M3J1NLJygoK8s/T4snazsXT68/O08HM1MnOxwr0xcwuICsgNyAoMDk1
KSAzNjMtMTExMSAoxM/CLiAxODE2KQrmwcvTICsgNyAoMDk1KSAzNjMtMTEyNQpFLW1haWwg
ZHZldGNoaW5raW5AcmJjLnJ1Cmh0dHA6Ly93d3cucmJjLnJ1Cgo=

--------------ms030506040901050904020802
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIH/zCC
AlowggHDoAMCAQICEHDA9gbTXw80Kzb3WzrbkBAwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MTIwNjE2MDM0MVoX
DTA4MTIwNTE2MDM0MVowRDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEhMB8G
CSqGSIb3DQEJARYSZHZldGNoaW5raW5AcmJjLnJ1MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCB
iQKBgQC0xSTcVG0sc88UFydbwKP9HCL82tH3dstJQRySE0nqzCpYXWNVQ48dJeQ1hSE+APid
LMiFnCKXqmIOLvJ3tFP4h6aT9VUJh+l+LiVOSWcQs72qfGnUvmhCL0WAz5GMotcnR3XcaYbu
i+c6E68W9LTQkmBKzsgtQ93b6YvrySk9WQIDAQABoy8wLTAdBgNVHREEFjAUgRJkdmV0Y2hp
bmtpbkByYmMucnUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQApUXMJBrI1BWGZ
QYvZday/MEFuRhjifw75oupBLmb5tpIKfr7TfktGJ9jLloYMqeyNnrg4NjPkWTedBGDfAyYg
ZdTY/5nwb7Tnim0CUDbvFwY6Rs3DjsrNfAeIdzD7ie51ZYbdh0oWe3rUk7598LEuEHkOllWc
EWSz9B5HZS6z3jCCAlowggHDoAMCAQICEHDA9gbTXw80Kzb3WzrbkBAwDQYJKoZIhvcNAQEF
BQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0
ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3
MTIwNjE2MDM0MVoXDTA4MTIwNTE2MDM0MVowRDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWls
IE1lbWJlcjEhMB8GCSqGSIb3DQEJARYSZHZldGNoaW5raW5AcmJjLnJ1MIGfMA0GCSqGSIb3
DQEBAQUAA4GNADCBiQKBgQC0xSTcVG0sc88UFydbwKP9HCL82tH3dstJQRySE0nqzCpYXWNV
Q48dJeQ1hSE+APidLMiFnCKXqmIOLvJ3tFP4h6aT9VUJh+l+LiVOSWcQs72qfGnUvmhCL0WA
z5GMotcnR3XcaYbui+c6E68W9LTQkmBKzsgtQ93b6YvrySk9WQIDAQABoy8wLTAdBgNVHREE
FjAUgRJkdmV0Y2hpbmtpbkByYmMucnUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOB
gQApUXMJBrI1BWGZQYvZday/MEFuRhjifw75oupBLmb5tpIKfr7TfktGJ9jLloYMqeyNnrg4
NjPkWTedBGDfAyYgZdTY/5nwb7Tnim0CUDbvFwY6Rs3DjsrNfAeIdzD7ie51ZYbdh0oWe3rU
k7598LEuEHkOllWcEWSz9B5HZS6z3jCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAw
gdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUg
VG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRp
b24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFp
bCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0w
MzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU
aGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwg
RnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV
+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfAr
hVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/
p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8
MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWls
Q0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxh
YmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/
TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amc
OY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggLjMIIC
3wIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5
KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQ
cMD2BtNfDzQrNvdbOtuQEDAJBgUrDgMCGgUAoIIBwzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcN
AQcBMBwGCSqGSIb3DQEJBTEPFw0wODAyMTkxNzE0MTlaMCMGCSqGSIb3DQEJBDEWBBRtyGWx
PzRFxjyOv8bj9ISfgDj4LTBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3
DQMCAgIAgDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDCBhQYJKwYB
BAGCNxAEMXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg
KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vpbmcg
Q0ECEHDA9gbTXw80Kzb3WzrbkBAwgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJa
QTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh
d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEHDA9gbTXw80Kzb3WzrbkBAwDQYJ
KoZIhvcNAQEBBQAEgYCqm1nuVAZ2Jct3FUWKrhDfRZ7dvLX85APXE8sKtOfY2SiQSmp+AMAz
vNrIHuQRAorqJJh/UAUXlZ38i0zYqyr/bCUjg6nJBg/96vLzd8aQmtn1y2qOsUCOeG9ndpoI
Fn1vSQZy2ZBcKICqk2sKAniKmFShD52TMRUgk/JZmksf8AAAAAAAAA==
--------------ms030506040901050904020802--