version bump

(Portage version: 2.0.54)

23 files changed, 1696 insertions, 195 deletions

diff --git a/dev-db/postgresql/ChangeLog b/dev-db/postgresql/ChangeLog
index 84eeb3019845..17abe2eae316 100644
--- a/dev-db/postgresql/ChangeLog
+++ b/dev-db/postgresql/ChangeLog
@@ -1,6 +1,24 @@
 # ChangeLog for dev-db/postgresql
 # Copyright 2002-2006 Gentoo Foundation; Distributed under the GPL v2
-# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/ChangeLog,v 1.258 2006/02/14 19:12:20 nakano Exp $
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/ChangeLog,v 1.259 2006/02/15 12:55:04 nakano Exp $
+
+*postgresql-8.0.7 (15 Feb 2006)
+*postgresql-7.4.12 (15 Feb 2006)
+*postgresql-7.3.14 (15 Feb 2006)
+
+  15 Feb 2006; Masatomo Nakano <nakano@gentoo.org>
+  +files/postgresql.init-7.3.14, +files/postgresql-7.3.14-gentoo.patch,
+  +files/pg_autovacuum.conf-7.4.12, +files/pg_autovacuum.init-7.4.12,
+  +files/postgresql.conf-7.4.12, +files/postgresql.init-7.4.12,
+  +files/postgresql-7.4.12-gentoo.patch,
+  +files/postgresql-7.4.12-hppa-testandset.patch,
+  +files/postgresql-7.4.12-vacuum-delay.patch,
+  +files/pg_autovacuum.conf-8.0.7, +files/pg_autovacuum.init-8.0.7,
+  +files/postgresql.conf-8.0.7, +files/postgresql.init-8.0.7,
+  +files/postgresql-8.0.7-gentoo.patch, +files/postgresql-8.0.7-sh.patch,
+  +postgresql-7.3.14.ebuild, +postgresql-7.4.12.ebuild,
+  +postgresql-8.0.7.ebuild:
+  Version bump.
 
 *postgresql-8.1.3 (14 Feb 2006)
 
diff --git a/dev-db/postgresql/Manifest b/dev-db/postgresql/Manifest
index 4241d819e2bf..a29b2585c181 100644
--- a/dev-db/postgresql/Manifest
+++ b/dev-db/postgresql/Manifest
@@ -1,291 +1,118 @@
 MD5 a06cdf4bb1c01090307f511abfb62afd ChangeLog 52142
-RMD160 f27dec0b451cb5f5460553f5568fa74fe4b40038 ChangeLog 52142
-SHA256 e9195d959974ae09fe7e8ec6204c7ee6bf0c22bb715629f8c5bfac0f7d71b37c ChangeLog 52142
 MD5 8ca6301197c0d45d7530d4117d087b15 files/CAN-2005-1409-doc.patch 1749
-RMD160 a01fb02931799230c9797dacba6f5d28b0b53ab9 files/CAN-2005-1409-doc.patch 1749
-SHA256 6f5e52a18b6fafd50c36659eb8c9980b7987ad262c88bb621640f352208f938b files/CAN-2005-1409-doc.patch 1749
 MD5 90acacf5efb7b8a73ec5d34128358c32 files/CAN-2005-1409.patch 1698
-RMD160 0384c424267752491141968fc4420c2d42f4e048 files/CAN-2005-1409.patch 1698
-SHA256 7236d1036ea0c30423044bddfde1610e0ac53e831fad5f40cf6cc9f43e7c1cf6 files/CAN-2005-1409.patch 1698
 MD5 3c53278e59e16caa55429700c0da42f9 files/CAN-2005-1410.patch 2843
-RMD160 6c7ad84e550b5a37b766355411cfb4f25709c864 files/CAN-2005-1410.patch 2843
-SHA256 582fb4ef7cc60a81a6b692a36a8eb319c44c85c4852a927322cad321d8d27a67 files/CAN-2005-1410.patch 2843
 MD5 419268f051162aee7f36e9c0b384fcc1 files/digest-postgresql-7.3.11 226
-RMD160 7add703f9526503b088ecc1240b8ee92f4120345 files/digest-postgresql-7.3.11 226
-SHA256 4b120a316fc872f7849c5899e46165b7f3a94e3252e0d9120936a138d0b1013b files/digest-postgresql-7.3.11 226
 MD5 04ecd457881525bf536086c9f2bf3101 files/digest-postgresql-7.3.13 226
-RMD160 c600aee62d76f79020246c650eb7c93ec1804896 files/digest-postgresql-7.3.13 226
-SHA256 62434a8343695aa1d2261be66e9d57ab151ca55eec152b56518b99dfe9cf7e76 files/digest-postgresql-7.3.13 226
+MD5 b9ed13bb998eb182ed2f738de12816e1 files/digest-postgresql-7.3.14 226
 MD5 3b4cbf59561d655b882ab335b892909d files/digest-postgresql-7.3.6-r2 223
-RMD160 ee56b1b1dd4f6bedd66713937a44d52862b143bd files/digest-postgresql-7.3.6-r2 223
-SHA256 5701ba17d0232ed7f340649afe6bac1e10e22f669b0ceb3fb70fb0672bb90bb1 files/digest-postgresql-7.3.6-r2 223
 MD5 f96713c7df9eb83197d57a6e22cdeedf files/digest-postgresql-7.3.9-r1 223
-RMD160 da7a883dda99a6b7ef139d8d345be09e165684a0 files/digest-postgresql-7.3.9-r1 223
-SHA256 878c629089910b7cf968d15223cbb2f70488e2fe182b47f8df9c9006f6ca0979 files/digest-postgresql-7.3.9-r1 223
 MD5 a994daa2e5f2b887175845eca4f8f708 files/digest-postgresql-7.4.11 293
-RMD160 34c8b019390dd48ac4922660384a097ff8823f59 files/digest-postgresql-7.4.11 293
-SHA256 e52a0c61856602479a8271860cf72c1b1671106bc58d68351d7f39043e642648 files/digest-postgresql-7.4.11 293
+MD5 c55bc4292feb256053b313a5bd684fb5 files/digest-postgresql-7.4.12 293
 MD5 b6200bc7bb2b1078ce182692c618f8a5 files/digest-postgresql-7.4.7-r1 290
-RMD160 4a070ccd639d109ec817276d6802e0821103d0a2 files/digest-postgresql-7.4.7-r1 290
-SHA256 dca67fdbc7ba396bd3b1723dd3b13a9845dea27980088382186d9c56986d2b9f files/digest-postgresql-7.4.7-r1 290
 MD5 b6200bc7bb2b1078ce182692c618f8a5 files/digest-postgresql-7.4.7-r2 290
-RMD160 4a070ccd639d109ec817276d6802e0821103d0a2 files/digest-postgresql-7.4.7-r2 290
-SHA256 dca67fdbc7ba396bd3b1723dd3b13a9845dea27980088382186d9c56986d2b9f files/digest-postgresql-7.4.7-r2 290
 MD5 4d7967107d2e9dbb6c097c637625023b files/digest-postgresql-7.4.8 290
-RMD160 7807efd72588d044b2f74010db540a6451c5c770 files/digest-postgresql-7.4.8 290
-SHA256 1a9ca60a8487d7b49d010cbfae7379093cc88c4c731e140490fbf5c0a3a9fa3a files/digest-postgresql-7.4.8 290
 MD5 b368c73c1f3a16e6aacf7f83feba9873 files/digest-postgresql-7.4.9 290
-RMD160 bd18d34e7e1dc770e25043dbad290c997c42c26c files/digest-postgresql-7.4.9 290
-SHA256 c5564d1c6af6c644caefa80a10397fd1a66eb5259157e59e30051c55ca739072 files/digest-postgresql-7.4.9 290
 MD5 6eaf9ba52385d9fc515d84cc4246db62 files/digest-postgresql-8.0.3 293
-RMD160 0d53cb107d6d8d02ee3307c8960992d176157fbb files/digest-postgresql-8.0.3 293
-SHA256 7129f760053e66ebeb4a736853bb4ff5cbb1c23c86bb67680347b80f0435ef98 files/digest-postgresql-8.0.3 293
 MD5 810c92c5829048772526b0b4c1d6c8dd files/digest-postgresql-8.0.4 489
-RMD160 04aac5188cf2e4bd9758462ded75660de4da1716 files/digest-postgresql-8.0.4 489
-SHA256 daeb444d0bee81c2e189403027bc71fe4c49be050bf3ea8eab344056093599d3 files/digest-postgresql-8.0.4 489
 MD5 4314ab3cdcef63d5376404c7d71023bf files/digest-postgresql-8.0.6 293
-RMD160 c012f9948ae4d9ced9a4d4f01a49174fcb209ae6 files/digest-postgresql-8.0.6 293
-SHA256 a410ff3c12dbd6854e28253225a672b6ad284586d25fd896f53fdaabb365cb19 files/digest-postgresql-8.0.6 293
+MD5 af57fbfd9396ef2b58207dbf530f02a5 files/digest-postgresql-8.0.7 293
 MD5 c1458813c4841ffdc0da30a9e2f76d01 files/digest-postgresql-8.1.2 223
-RMD160 bde4f26905985df4e6c0020b8b70669a210ab18b files/digest-postgresql-8.1.2 223
-SHA256 df967e9869b87217adaedeac7a16c254d82421473056439ae31db36f0bc6007c files/digest-postgresql-8.1.2 223
 MD5 4c03a8c23190af3a632a6ca9789ab6d5 files/digest-postgresql-8.1.3 223
-RMD160 66ffef4258ea870bc72b703684db31f183de0ab8 files/digest-postgresql-8.1.3 223
-SHA256 96c2ea0de8afd27b1ec1d2dc0bd0a69ff7994bfa6794539f8761b860c03b8528 files/digest-postgresql-8.1.3 223
 MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-7.4.11 302
-RMD160 8bdeef1a914659e7c55ce8d802b57cbeca6020bc files/pg_autovacuum.conf-7.4.11 302
-SHA256 9a8b0813bc67318f2df9e662fc067fa85ecd9bca2d19709715a94d5ab32bf721 files/pg_autovacuum.conf-7.4.11 302
+MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-7.4.12 302
 MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-7.4.7 302
-RMD160 8bdeef1a914659e7c55ce8d802b57cbeca6020bc files/pg_autovacuum.conf-7.4.7 302
-SHA256 9a8b0813bc67318f2df9e662fc067fa85ecd9bca2d19709715a94d5ab32bf721 files/pg_autovacuum.conf-7.4.7 302
 MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-7.4.8 302
-RMD160 8bdeef1a914659e7c55ce8d802b57cbeca6020bc files/pg_autovacuum.conf-7.4.8 302
-SHA256 9a8b0813bc67318f2df9e662fc067fa85ecd9bca2d19709715a94d5ab32bf721 files/pg_autovacuum.conf-7.4.8 302
 MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-7.4.9 302
-RMD160 8bdeef1a914659e7c55ce8d802b57cbeca6020bc files/pg_autovacuum.conf-7.4.9 302
-SHA256 9a8b0813bc67318f2df9e662fc067fa85ecd9bca2d19709715a94d5ab32bf721 files/pg_autovacuum.conf-7.4.9 302
 MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-8.0.3 302
-RMD160 8bdeef1a914659e7c55ce8d802b57cbeca6020bc files/pg_autovacuum.conf-8.0.3 302
-SHA256 9a8b0813bc67318f2df9e662fc067fa85ecd9bca2d19709715a94d5ab32bf721 files/pg_autovacuum.conf-8.0.3 302
 MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-8.0.4 302
-RMD160 8bdeef1a914659e7c55ce8d802b57cbeca6020bc files/pg_autovacuum.conf-8.0.4 302
-SHA256 9a8b0813bc67318f2df9e662fc067fa85ecd9bca2d19709715a94d5ab32bf721 files/pg_autovacuum.conf-8.0.4 302
 MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-8.0.6 302
-RMD160 8bdeef1a914659e7c55ce8d802b57cbeca6020bc files/pg_autovacuum.conf-8.0.6 302
-SHA256 9a8b0813bc67318f2df9e662fc067fa85ecd9bca2d19709715a94d5ab32bf721 files/pg_autovacuum.conf-8.0.6 302
+MD5 999379432735e7e6a71ec6ccd5a784e1 files/pg_autovacuum.conf-8.0.7 302
 MD5 e6efc761e2284959300e00943fdd37e8 files/pg_autovacuum.init-7.4.11 1415
-RMD160 35618b800621b8b887617bbccdb332b22d5c8832 files/pg_autovacuum.init-7.4.11 1415
-SHA256 af86cf4b90863abe969ebc3cf1999643006d7310a440b2276e79aec11b8d178e files/pg_autovacuum.init-7.4.11 1415
+MD5 47205de6356607e1442b27d9239cc899 files/pg_autovacuum.init-7.4.12 1415
 MD5 ffe7e2e6a0ae65238f2addcbbbba59d0 files/pg_autovacuum.init-7.4.7 1414
-RMD160 d199a15aed7afb7ee6949bd7b0d5c94462bc730a files/pg_autovacuum.init-7.4.7 1414
-SHA256 d153765d80043d9825f265c5f86abc5003c970c45cfbc1deaf268405890f269b files/pg_autovacuum.init-7.4.7 1414
 MD5 50be58ef7b752834f53ae86c70f75d9a files/pg_autovacuum.init-7.4.8 1414
-RMD160 1d7af860d4353430c9c24152ecdcfbcf342ced43 files/pg_autovacuum.init-7.4.8 1414
-SHA256 9ae24e4ac071bc6b0f4b2196b740c89bfc9ab08c5b1eb8c0ec762da2a0669912 files/pg_autovacuum.init-7.4.8 1414
 MD5 b35f19cbbb6d2ef9cdc62a3a61faed52 files/pg_autovacuum.init-7.4.9 1414
-RMD160 e8f9327c33ad2f2d9bc2754702b4f7c7d3f4cb7c files/pg_autovacuum.init-7.4.9 1414
-SHA256 7da7b9b499529451075457553e42d76884192aba6584180461adfa9a328c24cc files/pg_autovacuum.init-7.4.9 1414
 MD5 9b0d09ffaaa125d93a200e3783af23cc files/pg_autovacuum.init-8.0.3 1414
-RMD160 1876e10ea34e485d2df9c1b9a268a0f659a76d09 files/pg_autovacuum.init-8.0.3 1414
-SHA256 6d3f805ef0e128bac05f51d14022085f92e075e0517f35c946d6b1b343c1f19f files/pg_autovacuum.init-8.0.3 1414
 MD5 3d69e95f9646cfacb2ba866b3b6bd2af files/pg_autovacuum.init-8.0.4 1414
-RMD160 cb8d98625b46f677fcc77414a12885dad581a4b1 files/pg_autovacuum.init-8.0.4 1414
-SHA256 339bf5d359f4d4a9fdc9b571d380e18c387a6f0f6dc0c5ef2619c0e100b165c5 files/pg_autovacuum.init-8.0.4 1414
 MD5 ac0728eb97ad6adb664be79c73b74370 files/pg_autovacuum.init-8.0.6 1414
-RMD160 6be0d8deb0c55c1ced61743b76ecd4e97a871ed8 files/pg_autovacuum.init-8.0.6 1414
-SHA256 2d03a31129c3172ee4a86e453d5cf047117acd666af16d8be0e74a14855b3173 files/pg_autovacuum.init-8.0.6 1414
+MD5 56ee38badc4072b4c1bdf9f51685f56b files/pg_autovacuum.init-8.0.7 1414
 MD5 7fad73889572ccdf114ce0024e7170c6 files/postgresql-7.3.11-gentoo.patch 1741
-RMD160 4fb2f1a2c88432b62728582324d9ba4574b9225a files/postgresql-7.3.11-gentoo.patch 1741
-SHA256 b9d828a4b9ff1e2f753a4944db8bc40f474ffc49d129c55cc9efd8fd1dd8a16c files/postgresql-7.3.11-gentoo.patch 1741
 MD5 10d8a35a93fb7252cf9674f6affd7643 files/postgresql-7.3.13-gentoo.patch 1741
-RMD160 f9d6909ecf0edea0c2aec5d819aef6adf9109b5e files/postgresql-7.3.13-gentoo.patch 1741
-SHA256 6d2a27b388072d85c1bb78e3a7378145175fd9da6bd04c11b6c7d219f8d04d22 files/postgresql-7.3.13-gentoo.patch 1741
+MD5 24dbe742a511f6c7bba4cbd940c8c4b5 files/postgresql-7.3.14-gentoo.patch 1741
 MD5 4501816025cc701e272b5e57937d0de0 files/postgresql-7.3.9-gentoo.patch 529
-RMD160 1b2a484ab6f778d2c4ec7f9172272191766f2387 files/postgresql-7.3.9-gentoo.patch 529
-SHA256 5241da893d4f6d880597a0b52a09ef61df28955c7f38be736c31b2f8210ec51a files/postgresql-7.3.9-gentoo.patch 529
 MD5 dbe0601754b798a4d08f080137a57c43 files/postgresql-7.3.9-securityfix.patch 1443
-RMD160 f80f20c96bc1641c2e6749d6ea5a625ea224b7cb files/postgresql-7.3.9-securityfix.patch 1443
-SHA256 103cc6f0a3bdeee12819dd1641dcf3652df5d3103862afcb96a983104bd517f2 files/postgresql-7.3.9-securityfix.patch 1443
 MD5 ebabf34ee138e09c941f27b1fbf735a5 files/postgresql-7.4.11-gentoo.patch 1741
-RMD160 484c42bb0f00101830dd006b33164706cd62d1ef files/postgresql-7.4.11-gentoo.patch 1741
-SHA256 dd03b4669db061856bec385beb1f1fd0eb06b709c6405e56dbcf5d7f4ca19858 files/postgresql-7.4.11-gentoo.patch 1741
 MD5 edb862529983babeaece42f086c3c3ef files/postgresql-7.4.11-hppa-testandset.patch 1604
-RMD160 19b5078956e3c2ad2253b24cb06073ee364e24ae files/postgresql-7.4.11-hppa-testandset.patch 1604
-SHA256 2e6140fbc3c9fb8ecefe16d92f1dd84bd16fe8d76879885aedac48cd4d6fc9a4 files/postgresql-7.4.11-hppa-testandset.patch 1604
 MD5 2e87af398df0a957bf2f2dff754ac174 files/postgresql-7.4.11-vacuum-delay.patch 8918
-RMD160 dcd4fc4774277b0bf4a2158584c18bae2dc04232 files/postgresql-7.4.11-vacuum-delay.patch 8918
-SHA256 7112ea61b84ce5c6974cd74687039f2ef871e0b4b25a34b4394225c2695fc123 files/postgresql-7.4.11-vacuum-delay.patch 8918
+MD5 048439fadb678ce304dec9629829bcc2 files/postgresql-7.4.12-gentoo.patch 1741
+MD5 50c4723189d547a027340c928c0af87c files/postgresql-7.4.12-hppa-testandset.patch 1604
+MD5 2e87af398df0a957bf2f2dff754ac174 files/postgresql-7.4.12-vacuum-delay.patch 8918
 MD5 e91e3b293273f041b209aa65ff6ceebc files/postgresql-7.4.7-gentoo.patch 1160
-RMD160 da957b1d950aad734f0f2624e11e8948ae8311db files/postgresql-7.4.7-gentoo.patch 1160
-SHA256 d5c4eab076247d930c08e28784f91ead14419435f1aa40094a8a8b78dc396196 files/postgresql-7.4.7-gentoo.patch 1160
 MD5 bd8092be6ccc6918973d9654caacbfab files/postgresql-7.4.7-hppa-testandset.patch 1596
-RMD160 995296d67babb1e7a37da2afecaddca3f5423588 files/postgresql-7.4.7-hppa-testandset.patch 1596
-SHA256 d227967f1a96117cd5b7459713bf1c3c00b98182499880d23a6b0f7da6e584eb files/postgresql-7.4.7-hppa-testandset.patch 1596
 MD5 df4fedbfa30df690a6f78da9f5a44196 files/postgresql-7.4.7-securityfix.patch 1773
-RMD160 3c4bfc9c77b12632a5b2887c7362616916a3993e files/postgresql-7.4.7-securityfix.patch 1773
-SHA256 66383262ea8759c0b33e9cea438dcddb367cff3a406d281c83d92a19463bc826 files/postgresql-7.4.7-securityfix.patch 1773
 MD5 2e87af398df0a957bf2f2dff754ac174 files/postgresql-7.4.7-vacuum-delay.patch 8918
-RMD160 dcd4fc4774277b0bf4a2158584c18bae2dc04232 files/postgresql-7.4.7-vacuum-delay.patch 8918
-SHA256 7112ea61b84ce5c6974cd74687039f2ef871e0b4b25a34b4394225c2695fc123 files/postgresql-7.4.7-vacuum-delay.patch 8918
 MD5 1b27a8ad9d652b6d292ff34ad385b208 files/postgresql-7.4.8-gentoo.patch 1729
-RMD160 121ef1f11c872b2ced2e390f673897a6792f501a files/postgresql-7.4.8-gentoo.patch 1729
-SHA256 501a0dcc828533a1d7885eb5419fe53287a9c4ad5ab22c1e3b47957847359f4f files/postgresql-7.4.8-gentoo.patch 1729
 MD5 bd8092be6ccc6918973d9654caacbfab files/postgresql-7.4.8-hppa-testandset.patch 1596
-RMD160 995296d67babb1e7a37da2afecaddca3f5423588 files/postgresql-7.4.8-hppa-testandset.patch 1596
-SHA256 d227967f1a96117cd5b7459713bf1c3c00b98182499880d23a6b0f7da6e584eb files/postgresql-7.4.8-hppa-testandset.patch 1596
 MD5 2e87af398df0a957bf2f2dff754ac174 files/postgresql-7.4.8-vacuum-delay.patch 8918
-RMD160 dcd4fc4774277b0bf4a2158584c18bae2dc04232 files/postgresql-7.4.8-vacuum-delay.patch 8918
-SHA256 7112ea61b84ce5c6974cd74687039f2ef871e0b4b25a34b4394225c2695fc123 files/postgresql-7.4.8-vacuum-delay.patch 8918
 MD5 64cac596c308b19865f5738cc5af02b1 files/postgresql-7.4.9-gentoo.patch 1729
-RMD160 654e34a1f06696c9079284b0d636400703d475e3 files/postgresql-7.4.9-gentoo.patch 1729
-SHA256 945e65ffcf4131b3a79b004eaa9c5ab9983b57ac6bc4793879ef72715647f3c2 files/postgresql-7.4.9-gentoo.patch 1729
 MD5 bd8092be6ccc6918973d9654caacbfab files/postgresql-7.4.9-hppa-testandset.patch 1596
-RMD160 995296d67babb1e7a37da2afecaddca3f5423588 files/postgresql-7.4.9-hppa-testandset.patch 1596
-SHA256 d227967f1a96117cd5b7459713bf1c3c00b98182499880d23a6b0f7da6e584eb files/postgresql-7.4.9-hppa-testandset.patch 1596
 MD5 2e87af398df0a957bf2f2dff754ac174 files/postgresql-7.4.9-vacuum-delay.patch 8918
-RMD160 dcd4fc4774277b0bf4a2158584c18bae2dc04232 files/postgresql-7.4.9-vacuum-delay.patch 8918
-SHA256 7112ea61b84ce5c6974cd74687039f2ef871e0b4b25a34b4394225c2695fc123 files/postgresql-7.4.9-vacuum-delay.patch 8918
 MD5 01f69b667825048f2e9807555b79b73d files/postgresql-8.0.3-gentoo.patch 1200
-RMD160 618ab6b0cf1de0b83bdc67dfb6c203fde800b961 files/postgresql-8.0.3-gentoo.patch 1200
-SHA256 6e3c116bac7e69addf8530372abf4ec1bc94bde19f25d84dfcf675cf9cb9ad0e files/postgresql-8.0.3-gentoo.patch 1200
 MD5 fa95ac5bd802d7220fe9196de93fbe97 files/postgresql-8.0.3-sh.patch 618
-RMD160 a86d766d7465a3e92705ee5c27261028af07b8de files/postgresql-8.0.3-sh.patch 618
-SHA256 55fc732493195fb93838e3074bc552a9acad164298bc2c04b00b3cadf12bf144 files/postgresql-8.0.3-sh.patch 618
 MD5 01f69b667825048f2e9807555b79b73d files/postgresql-8.0.4-gentoo.patch 1200
-RMD160 618ab6b0cf1de0b83bdc67dfb6c203fde800b961 files/postgresql-8.0.4-gentoo.patch 1200
-SHA256 6e3c116bac7e69addf8530372abf4ec1bc94bde19f25d84dfcf675cf9cb9ad0e files/postgresql-8.0.4-gentoo.patch 1200
 MD5 fa95ac5bd802d7220fe9196de93fbe97 files/postgresql-8.0.4-sh.patch 618
-RMD160 a86d766d7465a3e92705ee5c27261028af07b8de files/postgresql-8.0.4-sh.patch 618
-SHA256 55fc732493195fb93838e3074bc552a9acad164298bc2c04b00b3cadf12bf144 files/postgresql-8.0.4-sh.patch 618
 MD5 290d9cac9f228e7479e316b68aadfd7c files/postgresql-8.0.6-gentoo.patch 1200
-RMD160 0bba8152556896c6bcdb7086d0f6b5dd5b4e8112 files/postgresql-8.0.6-gentoo.patch 1200
-SHA256 24c8b74a1b68de000003a4dff9768679fce76561182db1ffaa6723d161bf94bd files/postgresql-8.0.6-gentoo.patch 1200
 MD5 fa95ac5bd802d7220fe9196de93fbe97 files/postgresql-8.0.6-sh.patch 618
-RMD160 a86d766d7465a3e92705ee5c27261028af07b8de files/postgresql-8.0.6-sh.patch 618
-SHA256 55fc732493195fb93838e3074bc552a9acad164298bc2c04b00b3cadf12bf144 files/postgresql-8.0.6-sh.patch 618
+MD5 290d9cac9f228e7479e316b68aadfd7c files/postgresql-8.0.7-gentoo.patch 1200
+MD5 fa95ac5bd802d7220fe9196de93fbe97 files/postgresql-8.0.7-sh.patch 618
 MD5 241bb73cbd829c31037d86cd0530650b files/postgresql-8.1.2-gentoo.patch 1200
-RMD160 c4a478e0ab7418f540cf9989663a4b3cbbfca548 files/postgresql-8.1.2-gentoo.patch 1200
-SHA256 796bc0f5aa1cccc71a60f184021995fb503778b06024c84c30502139292640db files/postgresql-8.1.2-gentoo.patch 1200
 MD5 fa95ac5bd802d7220fe9196de93fbe97 files/postgresql-8.1.2-sh.patch 618
-RMD160 a86d766d7465a3e92705ee5c27261028af07b8de files/postgresql-8.1.2-sh.patch 618
-SHA256 55fc732493195fb93838e3074bc552a9acad164298bc2c04b00b3cadf12bf144 files/postgresql-8.1.2-sh.patch 618
 MD5 a8a16e7f40fc40211b4e497b0036aa7f files/postgresql-8.1.3-gentoo.patch 1200
-RMD160 41c3e001f530f7b67d2b6a346ad1a15b234670e9 files/postgresql-8.1.3-gentoo.patch 1200
-SHA256 ec9b02466ee78dc29aabb571f8ee5f324e116b300e7d23a1d33ae92842383799 files/postgresql-8.1.3-gentoo.patch 1200
 MD5 fa95ac5bd802d7220fe9196de93fbe97 files/postgresql-8.1.3-sh.patch 618
-RMD160 a86d766d7465a3e92705ee5c27261028af07b8de files/postgresql-8.1.3-sh.patch 618
-SHA256 55fc732493195fb93838e3074bc552a9acad164298bc2c04b00b3cadf12bf144 files/postgresql-8.1.3-sh.patch 618
 MD5 2b0c84d2c26622573d4e2b7e0518fdad files/postgresql.conf 375
-RMD160 88f1c276939d3f44b587d9a9edcc68d182b4a8b1 files/postgresql.conf 375
-SHA256 472edb3a023f708bc1b1a05c6b1f60addd81f7be8aeae19a8727b7e8166e64b0 files/postgresql.conf 375
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-7.4.11 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-7.4.11 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-7.4.11 390
+MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-7.4.12 390
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-7.4.7 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-7.4.7 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-7.4.7 390
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-7.4.8 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-7.4.8 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-7.4.8 390
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-7.4.9 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-7.4.9 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-7.4.9 390
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-8.0.3 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-8.0.3 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-8.0.3 390
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-8.0.4 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-8.0.4 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-8.0.4 390
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-8.0.6 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-8.0.6 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-8.0.6 390
+MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-8.0.7 390
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-8.1.2 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-8.1.2 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-8.1.2 390
 MD5 9787933dfca9cc3858468186231a9df1 files/postgresql.conf-8.1.3 390
-RMD160 f72be2badb3c8893825c6a9cef417a28cc58ac49 files/postgresql.conf-8.1.3 390
-SHA256 f4a4a40be4b60869e55b8e5408d29c9d458e0b04a01498f0d6919f6afbcac13e files/postgresql.conf-8.1.3 390
 MD5 4165a3ef6d3e253340b56c719a866c87 files/postgresql.init-7.3.11 1280
-RMD160 4ea2dc3b3e1449f11433c10745e2c6d61da755fb files/postgresql.init-7.3.11 1280
-SHA256 1abc7773ab17920d1d3ea21f19746a2bcd7b6dce4f4af20d01cafb8e9ba138f7 files/postgresql.init-7.3.11 1280
 MD5 680e9480b1eb1357df7dd92ab6b1dd75 files/postgresql.init-7.3.13 1280
-RMD160 3f7594ae3093cc71dd6cf5a1eed8074ab63eb27d files/postgresql.init-7.3.13 1280
-SHA256 b415e43d01d117ee3585af977d460a642ddd75bda21c456c423cd2145877660a files/postgresql.init-7.3.13 1280
+MD5 3153743abb79a3bbd81bd2bb4841ea4f files/postgresql.init-7.3.14 1280
 MD5 6237c18ae647e118e23425e3cb28c8aa files/postgresql.init-7.3.6 1279
-RMD160 0e2733c98116489d28f1d2ec6212f5743bba9f31 files/postgresql.init-7.3.6 1279
-SHA256 911226e5794cc89961f6e6380814d5d502e248a4eee32d084487183b1f2ea5c6 files/postgresql.init-7.3.6 1279
 MD5 5d90779b8c5b7d63ea0846f2a534fc87 files/postgresql.init-7.3.9 1279
-RMD160 c7bd7d0a72c26026eebe9a6b9b53d855822a1cb2 files/postgresql.init-7.3.9 1279
-SHA256 6c9dd041b32d5ef4076b1b7720168b93ba501ffcb20264269c96a04299452f23 files/postgresql.init-7.3.9 1279
 MD5 dc0694b879d17adc7e5504bfa64c9f4b files/postgresql.init-7.4.11 1280
-RMD160 81ab4a7b63f6e74eeefd9f6839691b21dd1a6699 files/postgresql.init-7.4.11 1280
-SHA256 47b63ea12bdb53c97f03daf461bbd89c866927abc44c6d4466a2fe6f80ce0578 files/postgresql.init-7.4.11 1280
+MD5 98fb237fc436c7f0d54ec1bcc353510b files/postgresql.init-7.4.12 1280
 MD5 8b2a2b4c8f40a1fdbe73d7a6fbcfb6fe files/postgresql.init-7.4.7 1279
-RMD160 e9e0b6898d35d354d40a63e380f4142f3787db6a files/postgresql.init-7.4.7 1279
-SHA256 e5cf8852854adfed655933315c5446e70f36759496944b0c0d8c1a9bc8e0f9fe files/postgresql.init-7.4.7 1279
 MD5 eae31db55e9908de6d955d3efc931bbc files/postgresql.init-7.4.8 1279
-RMD160 cdbb7073996952068a6f085ef628dbe612031f51 files/postgresql.init-7.4.8 1279
-SHA256 80e3033b0408c28bdbf5b73df6cb10ac82a40002397134d74e6daf8b3a185f10 files/postgresql.init-7.4.8 1279
 MD5 37e9be11579a5dd887ea56898555a013 files/postgresql.init-7.4.9 1279
-RMD160 88c490bf5b432a39127ab45842a5ffee4367398e files/postgresql.init-7.4.9 1279
-SHA256 bbe9fb4f5374de9c91ab4565166b34edfdf363023cc4b54522de68be9bdf1b2c files/postgresql.init-7.4.9 1279
 MD5 b7252dad787e4e9f4d645a47d7f74ad8 files/postgresql.init-8.0.3 1279
-RMD160 04364a9cc459ec245e43d2a4a29b391fc5647c4d files/postgresql.init-8.0.3 1279
-SHA256 0b77a0002bb79c7e1f9e76df87400a5536ac7d7c3bf9970116dc49082d6683d1 files/postgresql.init-8.0.3 1279
 MD5 11eb946998d42bb657f9408b804b3099 files/postgresql.init-8.0.4 1279
-RMD160 d380c3f42f2b7e635e5ad5c70d2bec63ad33af5b files/postgresql.init-8.0.4 1279
-SHA256 65ebdf27972a0adb2317a91d3727803c80bc329f86bfded55d9bdde1ef78a55d files/postgresql.init-8.0.4 1279
 MD5 707d5e3629dc849b2388c5d5cd117f5b files/postgresql.init-8.0.6 1279
-RMD160 bd32f15f7d7b6d0106293d618272ca7bb09e1698 files/postgresql.init-8.0.6 1279
-SHA256 f9530c7fc50815da92cef9263f7078fb010de950de58b602617d515e2bc8f968 files/postgresql.init-8.0.6 1279
+MD5 dda73a706ae7ca3b8f4670c58c96e99f files/postgresql.init-8.0.7 1279
 MD5 ab1b8fa9b6fc1ef8c17962be36b5fbc3 files/postgresql.init-8.1.2 1279
-RMD160 36fd1212f25c8d3ae23fbf672b3f6c7ac83daded files/postgresql.init-8.1.2 1279
-SHA256 a4fb32d84c971e8b66c5ab7537ef5eb79f99057f097de4b740125f03e4eb43ca files/postgresql.init-8.1.2 1279
 MD5 131571cfc7e88de3b13725f6b6da91df files/postgresql.init-8.1.3 1279
-RMD160 94b7af3e6cad645eabe96e17a57ce482faa13263 files/postgresql.init-8.1.3 1279
-SHA256 af6e3161e7e2c7756f249910f33c35ad5860415f14a67dd2c1e59bfc7ec224ee files/postgresql.init-8.1.3 1279
 MD5 f8d3d207746da2a3cd14dcaab8daab76 metadata.xml 163
-RMD160 70bbda1c1e8316a09d467334131898ae833a3205 metadata.xml 163
-SHA256 f0699a4c3ad24cc38836c2d4a1ba03e4e403a9a5364b51df405db02014005891 metadata.xml 163
 MD5 a3db434dc313b7d93c34e83a354a6a85 postgresql-7.3.11.ebuild 8315
-RMD160 e5766b0787b056c960fac8310bcb4e322d5dd8b8 postgresql-7.3.11.ebuild 8315
-SHA256 cc79036f587a6c5386a9bd38f70f227cd71a65d6574aeab37d8d90c912a99e66 postgresql-7.3.11.ebuild 8315
 MD5 7aa62e5bde9cd1b8fef5cfd18bb6f013 postgresql-7.3.13.ebuild 8413
-RMD160 db49794293f87b300bfe64007cc52eb5d8957b39 postgresql-7.3.13.ebuild 8413
-SHA256 a264a12142df700af933c260f91f25124fdd8d41fc37305da50c280903319846 postgresql-7.3.13.ebuild 8413
+MD5 2bd825ef5acb9181ece667ca131d268e postgresql-7.3.14.ebuild 8413
 MD5 c25c9a7ffe3a89d13b05d6030f4d9889 postgresql-7.3.6-r2.ebuild 7837
-RMD160 ea5870a74e4a31a37580f2a47a488c7691852780 postgresql-7.3.6-r2.ebuild 7837
-SHA256 d0473e726c26d665980f7a12b499070c9a2a6651c33dfdf0b19151cc861ea62e postgresql-7.3.6-r2.ebuild 7837
 MD5 2265cba6143f2d8471e41be421367c5b postgresql-7.3.9-r1.ebuild 8028
-RMD160 a5e1979cdba685ca13614478b6896002938095de postgresql-7.3.9-r1.ebuild 8028
-SHA256 d543f41b27f0e710de2ddc9908e1397dadde9c71a47bdf92d2ff1c2d23858d1e postgresql-7.3.9-r1.ebuild 8028
 MD5 174099f06ce2e3f4ce99fc7bbb7f3784 postgresql-7.4.11.ebuild 10687
-RMD160 752b62efa4ac88e2e2d9d8b971a9d733c42b1aa5 postgresql-7.4.11.ebuild 10687
-SHA256 1bc6c7a8400e867327fecae79f2bdb86e79ae57920d5dfc57671b1d68ab0f73c postgresql-7.4.11.ebuild 10687
+MD5 aae67c715f96bcdee43d8ff12d7ed885 postgresql-7.4.12.ebuild 10687
 MD5 993f8413e91946fb334582c36b39afcb postgresql-7.4.7-r1.ebuild 10701
-RMD160 8c4784e465c03370b438cfdd672ec62f5559cec4 postgresql-7.4.7-r1.ebuild 10701
-SHA256 0c7f69322a86dd7bb9061d8fa48966dadce3efba33841d57cdb453a0906b6b09 postgresql-7.4.7-r1.ebuild 10701
 MD5 481cefe9ed2cc621fe58174c1a7514f9 postgresql-7.4.7-r2.ebuild 10855
-RMD160 79a84d68e5b252ff6cd20857f62f5f1eb75250e4 postgresql-7.4.7-r2.ebuild 10855
-SHA256 e778b10eeda9bfa6ac4e653ddbba75020e83bf7eb1376efd699e71fbd3de09a4 postgresql-7.4.7-r2.ebuild 10855
 MD5 0fb1a242fabdc15f2e68fa013c5c1292 postgresql-7.4.8.ebuild 10572
-RMD160 cfba95b77edf37f5253a0080aefc0a4e4751119c postgresql-7.4.8.ebuild 10572
-SHA256 50dc09757503960df1c8bb83b60a9c4d07c896f4b3aca4a3f37f25ea057cd834 postgresql-7.4.8.ebuild 10572
 MD5 90be6b9784005969409e6f55bcb0af76 postgresql-7.4.9.ebuild 10738
-RMD160 2f3ab0a2341a2c69265a0c23558dcf0ce1c7744f postgresql-7.4.9.ebuild 10738
-SHA256 0aa9665c752d584ab9ecae09f71e7b17a03d1779fdbb4658ba06dcddcf66e568 postgresql-7.4.9.ebuild 10738
 MD5 0ab1b6f2bce8c619c7824a648f44667b postgresql-8.0.3.ebuild 7510
-RMD160 07ed32d47feaae645dc3e7de800984871781ac96 postgresql-8.0.3.ebuild 7510
-SHA256 9255efa00c6ab0d1e9e47276bab3b3c8475218a3bef2f87bec83cde61219ea15 postgresql-8.0.3.ebuild 7510
 MD5 d358a0783c2e02f6cbb3ca0095500feb postgresql-8.0.4.ebuild 7681
-RMD160 12dd56cf8ad6f5f0eec0e56f0ea46edfa7b8070c postgresql-8.0.4.ebuild 7681
-SHA256 30ba21d0734e72be9ddd43467f9640f18393e19a768e9c49fd47e8bc2c2d415b postgresql-8.0.4.ebuild 7681
 MD5 1d94143a495b0a564206f995b4c58030 postgresql-8.0.6.ebuild 7633
-RMD160 d06557907abad6054b72d848722b3dc3863e3595 postgresql-8.0.6.ebuild 7633
-SHA256 10c025959b1cb777a1ac15f9749ad6976f1e0010579d4ad4385c8ce9a64d8316 postgresql-8.0.6.ebuild 7633
+MD5 0db2a8ba5df3f1ba8871661e0de063e7 postgresql-8.0.7.ebuild 7633
 MD5 80a1a1d30549701a852fab63217c0c4f postgresql-8.1.2.ebuild 7570
-RMD160 ab17d698f35014c86b826f869ebb51a5054a220a postgresql-8.1.2.ebuild 7570
-SHA256 93e9655115ab5d87b9f3f99574bd8fba900510be7bdc6af15bd941c5654a53dc postgresql-8.1.2.ebuild 7570
 MD5 8bcab7cf12b4db7a91a08f89eb2d1d7b postgresql-8.1.3.ebuild 7570
-RMD160 1f9e177722477a41690ed21a1a02498be167aeda postgresql-8.1.3.ebuild 7570
-SHA256 aa1621e05cfe96b4f9c96ca4e6d5df23c756a5c803d22bb7f8cf4f823da3cc68 postgresql-8.1.3.ebuild 7570
diff --git a/dev-db/postgresql/files/digest-postgresql-7.3.14 b/dev-db/postgresql/files/digest-postgresql-7.3.14
new file mode 100644
index 000000000000..4907be0e5c43
--- /dev/null
+++ b/dev-db/postgresql/files/digest-postgresql-7.3.14
@@ -0,0 +1,3 @@
+MD5 bb925420098bd7921a8684d7f279bc97 postgresql-base-7.3.14.tar.bz2 5669000
+MD5 94d403ab6d06efdc3c7925fd1f003d23 postgresql-docs-7.3.14.tar.bz2 2352329
+MD5 984035524d18c1597771b17b0ab440cb postgresql-opt-7.3.14.tar.bz2 340579
diff --git a/dev-db/postgresql/files/digest-postgresql-7.4.12 b/dev-db/postgresql/files/digest-postgresql-7.4.12
new file mode 100644
index 000000000000..4e61409b206e
--- /dev/null
+++ b/dev-db/postgresql/files/digest-postgresql-7.4.12
@@ -0,0 +1,4 @@
+MD5 16d037213b879963724da7809a0a1589 hier-Pg7.4-0.5.3.tar.gz 34662
+MD5 289b9cbb231bc0adb757641edd9508a8 postgresql-base-7.4.12.tar.bz2 6601251
+MD5 79b0ac16295e5a72380320ed17ec42d2 postgresql-docs-7.4.12.tar.bz2 2430951
+MD5 02fbdaa2c9f625412e0e4b5d693c31e6 postgresql-opt-7.4.12.tar.bz2 332088
diff --git a/dev-db/postgresql/files/digest-postgresql-8.0.7 b/dev-db/postgresql/files/digest-postgresql-8.0.7
new file mode 100644
index 000000000000..fb11b0004ec7
--- /dev/null
+++ b/dev-db/postgresql/files/digest-postgresql-8.0.7
@@ -0,0 +1,4 @@
+MD5 1d410cfb38253675fee36c8f9ee655e2 hier-Pg8.0.1-0.5.4.diff.gz 30662
+MD5 8d15064ffa1da6ee6629a444f782c7dd postgresql-base-8.0.7.tar.bz2 7824746
+MD5 d8159d0cc01b35fec59d181d1d16a5e0 postgresql-docs-8.0.7.tar.bz2 2255231
+MD5 e18314b1d70f2b0bae83cc31b1aa3192 postgresql-opt-8.0.7.tar.bz2 134524
diff --git a/dev-db/postgresql/files/pg_autovacuum.conf-7.4.12 b/dev-db/postgresql/files/pg_autovacuum.conf-7.4.12
new file mode 100644
index 000000000000..f342ebfd2a47
--- /dev/null
+++ b/dev-db/postgresql/files/pg_autovacuum.conf-7.4.12
@@ -0,0 +1,14 @@
+# The PostgreSQL user is:
+PGUSER=postgres
+
+# LOG file is:
+PG_AUTOVACUUM_LOG=/var/lib/postgresql/data/pg_autovacuum.log
+
+# See the pg_autovacuum documentation for the details of how these
+# parameters affect pg_autovacuum's aggressiveness.
+
+VACUUM_BASE=1000
+VACUUM_SCALE=2
+
+SLEEP_BASE=300
+SLEEP_SCALE=2
diff --git a/dev-db/postgresql/files/pg_autovacuum.conf-8.0.7 b/dev-db/postgresql/files/pg_autovacuum.conf-8.0.7
new file mode 100644
index 000000000000..f342ebfd2a47
--- /dev/null
+++ b/dev-db/postgresql/files/pg_autovacuum.conf-8.0.7
@@ -0,0 +1,14 @@
+# The PostgreSQL user is:
+PGUSER=postgres
+
+# LOG file is:
+PG_AUTOVACUUM_LOG=/var/lib/postgresql/data/pg_autovacuum.log
+
+# See the pg_autovacuum documentation for the details of how these
+# parameters affect pg_autovacuum's aggressiveness.
+
+VACUUM_BASE=1000
+VACUUM_SCALE=2
+
+SLEEP_BASE=300
+SLEEP_SCALE=2
diff --git a/dev-db/postgresql/files/pg_autovacuum.init-7.4.12 b/dev-db/postgresql/files/pg_autovacuum.init-7.4.12
new file mode 100644
index 000000000000..ca9f1a7a0980
--- /dev/null
+++ b/dev-db/postgresql/files/pg_autovacuum.init-7.4.12
@@ -0,0 +1,51 @@
+#!/sbin/runscript
+# Copyright 1999-2004 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/files/pg_autovacuum.init-7.4.12,v 1.1 2006/02/15 12:55:05 nakano Exp $
+
+depend() {
+	need postgresql logger
+}
+
+start() {
+	ebegin "Starting pg_autovacuum"
+	echo ""
+	echo -n "Waiting max. 10 sec. for postgresql to start "
+	CONTINUE=0
+	TOO_LONG=0
+	while [ "$CONTINUE" -eq 0 ] && [ $TOO_LONG -lt 10 ]
+	do
+		psql -U $PGUSER -d template1 -c "SELECT 1" 1> /dev/null 2> /dev/null
+		if [ "$?" -eq 0 ]
+		then
+			CONTINUE=1
+		else
+			echo -n "."
+			TOO_LONG=`expr $TOO_LONG + 1`
+			sleep 1
+		fi
+	done
+	start-stop-daemon -o --chuid $PGUSER --start --quiet --exec /usr/bin/pg_autovacuum -- -D -v $VACUUM_BASE -V $VACUUM_SCALE -s $SLEEP_BASE -S $SLEEP_SCALE -L $PG_AUTOVACUUM_LOG
+
+	sleep 1
+	pidof /usr/bin/pg_autovacuum > /dev/null
+	if [ $? -eq 0 ]; then
+		eend 0
+	else
+		eerror ""
+		eerror "Please see log file: $PG_AUTOVACUUM_LOG"
+		eerror "You may need to add following lines in /var/lib/postgresql/data/postgresql.conf and restart PostgreSQL."
+		eerror " stats_start_collector = true"
+		eerror " stats_row_level = true"
+
+		eerror "Please read ___DOCDIR___/contrib/README.pg_autovacuum for details."
+		eend 1
+	fi
+}
+
+stop() {
+	ebegin "Stopping pg_autovacuum"
+	start-stop-daemon --stop --quiet --exec /usr/bin/pg_autovacuum
+	result=$?
+	eend $result
+}
diff --git a/dev-db/postgresql/files/pg_autovacuum.init-8.0.7 b/dev-db/postgresql/files/pg_autovacuum.init-8.0.7
new file mode 100644
index 000000000000..fe630e64c3a2
--- /dev/null
+++ b/dev-db/postgresql/files/pg_autovacuum.init-8.0.7
@@ -0,0 +1,51 @@
+#!/sbin/runscript
+# Copyright 1999-2004 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/files/pg_autovacuum.init-8.0.7,v 1.1 2006/02/15 12:55:05 nakano Exp $
+
+depend() {
+	need postgresql logger
+}
+
+start() {
+	ebegin "Starting pg_autovacuum"
+	echo ""
+	echo -n "Waiting max. 10 sec. for postgresql to start "
+	CONTINUE=0
+	TOO_LONG=0
+	while [ "$CONTINUE" -eq 0 ] && [ $TOO_LONG -lt 10 ]
+	do
+		psql -U $PGUSER -d template1 -c "SELECT 1" 1> /dev/null 2> /dev/null
+		if [ "$?" -eq 0 ]
+		then
+			CONTINUE=1
+		else
+			echo -n "."
+			TOO_LONG=`expr $TOO_LONG + 1`
+			sleep 1
+		fi
+	done
+	start-stop-daemon -o --chuid $PGUSER --start --quiet --exec /usr/bin/pg_autovacuum -- -D -v $VACUUM_BASE -V $VACUUM_SCALE -s $SLEEP_BASE -S $SLEEP_SCALE -L $PG_AUTOVACUUM_LOG
+
+	sleep 1
+	pidof /usr/bin/pg_autovacuum > /dev/null
+	if [ $? -eq 0 ]; then
+		eend 0
+	else
+		eerror ""
+		eerror "Please see log file: $PG_AUTOVACUUM_LOG"
+		eerror "You may need to add following lines in /var/lib/postgresql/data/postgresql.conf and restart PostgreSQL."
+		eerror " stats_start_collector = true"
+		eerror " stats_row_level = true"
+
+		eerror "Please read ___DOCDIR___/contrib/README.pg_autovacuum for details."
+		eend 1
+	fi
+}
+
+stop() {
+	ebegin "Stopping pg_autovacuum"
+	start-stop-daemon --stop --quiet --exec /usr/bin/pg_autovacuum
+	result=$?
+	eend $result
+}
diff --git a/dev-db/postgresql/files/postgresql-7.3.14-gentoo.patch b/dev-db/postgresql/files/postgresql-7.3.14-gentoo.patch
new file mode 100644
index 000000000000..3c0776ef2fde
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql-7.3.14-gentoo.patch
@@ -0,0 +1,51 @@
+diff -Naru postgresql-7.3.14.org/src/interfaces/Makefile postgresql-7.3.14/src/interfaces/Makefile
+--- postgresql-7.3.14.org/src/interfaces/Makefile	2004-04-20 01:33:51.000000000 +0100
++++ postgresql-7.3.14/src/interfaces/Makefile	2005-05-09 21:59:15.000000000 +0100
+@@ -12,7 +12,7 @@
+ top_builddir = ../..
+ include $(top_builddir)/src/Makefile.global
+ 
+-DIRS := libpq ecpg 
++DIRS := ecpg 
+ 
+ ALLDIRS := $(DIRS) 
+ 
+diff -Naru postgresql-7.3.14.org/src/Makefile postgresql-7.3.14/src/Makefile
+--- postgresql-7.3.14.org/src/Makefile	2005-01-13 18:23:21.000000000 +0000
++++ postgresql-7.3.14/src/Makefile	2005-05-09 21:59:54.000000000 +0100
+@@ -18,7 +18,6 @@
+ 	$(MAKE) -C timezone $@
+ 	$(MAKE) -C backend $@
+ 	$(MAKE) -C backend/utils/mb/conversion_procs $@
+-	$(MAKE) -C include $@
+ 	$(MAKE) -C interfaces $@
+ 	$(MAKE) -C bin $@
+ 	$(MAKE) -C pl $@
+@@ -47,7 +46,6 @@
+ 	$(MAKE) -C port $@
+ 	$(MAKE) -C timezone $@
+ 	$(MAKE) -C backend $@
+-	$(MAKE) -C include $@
+ 	$(MAKE) -C interfaces $@
+ 	$(MAKE) -C bin $@
+ 	$(MAKE) -C pl $@
+@@ -61,7 +59,6 @@
+ 	-$(MAKE) -C port $@
+ 	-$(MAKE) -C timezone $@
+ 	-$(MAKE) -C backend $@
+-	-$(MAKE) -C include $@
+ 	-$(MAKE) -C interfaces $@
+ 	-$(MAKE) -C bin $@
+ 	-$(MAKE) -C pl $@
+diff -Naru postgresql-7.3.14.org/configure postgresql-7.3.14/configure
+--- postgresql-7.3.14.org/configure	2004-08-15 01:51:58.000000000 +0100
++++ postgresql-7.3.14/configure	2004-10-03 00:24:38.477010826 +0100
+@@ -5871,7 +5871,7 @@
+   echo $ECHO_N "(cached) $ECHO_C" >&6
+ else
+   pgac_cv_check_readline=no
+-for pgac_lib in "" " -ltermcap" " -lncurses" " -lcurses" ; do
++for pgac_lib in "" " -lncurses" " -lcurses" ; do
+   for pgac_rllib in -lreadline -ledit ; do
+     pgac_save_LIBS=$LIBS
+     LIBS="${pgac_rllib}${pgac_lib} $LIBS"
diff --git a/dev-db/postgresql/files/postgresql-7.4.12-gentoo.patch b/dev-db/postgresql/files/postgresql-7.4.12-gentoo.patch
new file mode 100644
index 000000000000..536189faed33
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql-7.4.12-gentoo.patch
@@ -0,0 +1,51 @@
+diff -Naru postgresql-7.4.12.org/configure postgresql-7.4.12/configure
+--- postgresql-7.4.12.org/configure	2004-08-18 04:11:24.000000000 +0100
++++ postgresql-7.4.12/configure	2004-09-15 20:28:46.933631781 +0100
+@@ -6003,7 +6003,7 @@
+   echo $ECHO_N "(cached) $ECHO_C" >&6
+ else
+   pgac_cv_check_readline=no
+-for pgac_lib in "" " -ltermcap" " -lncurses" " -lcurses" ; do
++for pgac_lib in "" " -lncurses" " -lcurses" ; do
+   for pgac_rllib in -lreadline -ledit ; do
+     pgac_save_LIBS=$LIBS
+     LIBS="${pgac_rllib}${pgac_lib} $LIBS"
+diff -Naru postgresql-7.4.12.org/src/interfaces/Makefile postgresql-7.4.12/src/interfaces/Makefile
+--- postgresql-7.4.12.org/src/interfaces/Makefile	2004-04-20 01:33:51.000000000 +0100
++++ postgresql-7.4.12/src/interfaces/Makefile	2005-05-09 21:59:15.000000000 +0100
+@@ -12,7 +12,7 @@
+ top_builddir = ../..
+ include $(top_builddir)/src/Makefile.global
+ 
+-DIRS := libpq ecpg 
++DIRS := ecpg 
+ 
+ ALLDIRS := $(DIRS) 
+ 
+diff -Naru postgresql-7.4.12.org/src/Makefile postgresql-7.4.12/src/Makefile
+--- postgresql-7.4.12.org/src/Makefile	2005-01-13 18:23:21.000000000 +0000
++++ postgresql-7.4.12/src/Makefile	2005-05-09 21:59:54.000000000 +0100
+@@ -18,7 +18,6 @@
+ 	$(MAKE) -C timezone $@
+ 	$(MAKE) -C backend $@
+ 	$(MAKE) -C backend/utils/mb/conversion_procs $@
+-	$(MAKE) -C include $@
+ 	$(MAKE) -C interfaces $@
+ 	$(MAKE) -C bin $@
+ 	$(MAKE) -C pl $@
+@@ -47,7 +46,6 @@
+ 	$(MAKE) -C port $@
+ 	$(MAKE) -C timezone $@
+ 	$(MAKE) -C backend $@
+-	$(MAKE) -C include $@
+ 	$(MAKE) -C interfaces $@
+ 	$(MAKE) -C bin $@
+ 	$(MAKE) -C pl $@
+@@ -61,7 +59,6 @@
+ 	-$(MAKE) -C port $@
+ 	-$(MAKE) -C timezone $@
+ 	-$(MAKE) -C backend $@
+-	-$(MAKE) -C include $@
+ 	-$(MAKE) -C interfaces $@
+ 	-$(MAKE) -C bin $@
+ 	-$(MAKE) -C pl $@
diff --git a/dev-db/postgresql/files/postgresql-7.4.12-hppa-testandset.patch b/dev-db/postgresql/files/postgresql-7.4.12-hppa-testandset.patch
new file mode 100644
index 000000000000..dc3313146d7a
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql-7.4.12-hppa-testandset.patch
@@ -0,0 +1,52 @@
+diff -urN postgresql-7.4.12.orig/src/include/port/linux.h postgresql-7.4.12/src/include/port/linux.h
+--- postgresql-7.4.12.orig/src/include/port/linux.h	2003-10-26 01:41:10.000000000 +0000
++++ postgresql-7.4.12/src/include/port/linux.h	2004-01-09 20:22:50.000000000 +0000
+@@ -3,6 +3,11 @@
+ 
+ #define HAS_TEST_AND_SET
+ 
++#elif defined(__hppa__)
++typedef struct { int sema[4]; } slock_t;
++
++#define HAS_TEST_AND_SET
++
+ #elif defined(__sparc__)
+ typedef unsigned char slock_t;
+ 
+diff -urN postgresql-7.4.12.orig/src/include/storage/s_lock.h postgresql-7.4.12/src/include/storage/s_lock.h
+--- postgresql-7.4.12.orig/src/include/storage/s_lock.h	2003-11-04 09:43:56.000000000 +0000
++++ postgresql-7.4.12/src/include/storage/s_lock.h	2004-01-09 20:12:15.000000000 +0000
+@@ -112,6 +112,33 @@
+ 
+ #endif	 /* __i386__ || __x86_64__ */
+ 
++#if defined(__hppa__) || defined(__hppa)
++#define TAS(lock) tas(lock)
++
++#define __ldcw(a) ({ \
++	unsigned int __ret;						\
++	__asm__ __volatile__("ldcw 0(%2),%0"				\
++				: "=r" (__ret), "=m" (*(a)) : "r" (a));	\
++	__ret;								\
++})
++
++#define __PA_LDCW_ALIGNMENT 16
++#define __ldcw_align(a) ({ \
++	volatile unsigned int __ret = (unsigned int) a;					\
++	if ((__ret & ~(__PA_LDCW_ALIGNMENT - 1)) < (unsigned int) a)			\
++		__ret = (__ret & ~(__PA_LDCW_ALIGNMENT - 1)) + __PA_LDCW_ALIGNMENT;	\
++	(unsigned int *) __ret;								\
++})
++
++static __inline__ int
++tas(volatile slock_t *lock)
++{
++	volatile unsigned int *a = __ldcw_align (lock);
++	return (__ldcw(a) == 0);
++}
++
++#endif	/* __hppa__ || __hppa */
++
+ 
+ /* Intel Itanium */
+ #if defined(__ia64__) || defined(__ia64)
diff --git a/dev-db/postgresql/files/postgresql-7.4.12-vacuum-delay.patch b/dev-db/postgresql/files/postgresql-7.4.12-vacuum-delay.patch
new file mode 100644
index 000000000000..e0f499859009
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql-7.4.12-vacuum-delay.patch
@@ -0,0 +1,284 @@
+    * From: Jan Wieck <JanWieck ( at ) Yahoo ( dot ) com>

+    * To: "Matthew T. O'Connor" <matthew ( at ) zeut ( dot ) net>

+    * Subject: Re: Performance features the 4th

+    * Date: Sun, 09 Nov 2003 18:42:53 -0500

+

+Matthew T. O'Connor wrote:

+

+    ----- Original Message ----- From: "Jan Wieck" <JanWieck ( at ) Yahoo ( dot ) com>

+

+Tom Lane wrote:

+> Gaetano and a couple of other people did experiments that seemed to show

+> it was useful.  I think we'd want to change the shape of the knob per

+> later suggestions (sleep 10 ms every N blocks, instead of N ms every

+> block) but it did seem that there was useful bang for little buck there.

+

+

+        I thought it was "sleep N ms every M blocks".

+

+Have we seen any numbers? Anything at all? Something that gives us a

+clue by what factor one has to multiply the total time a "VACUUM

+ANALYZE" takes, to get what effect in return?

+

+

+I have some time on sunday to do some testing.  Is there a patch that I can

+apply that implements either of the two options? (sleep 10ms every M blocks

+or sleep N ms every M blocks).

+

+

+I know Tom posted the original patch that sleept N ms every 1 block (where N

+is > 10 due to OS limitations).  Jan can you post a patch that has just the

+sleep code in it? Or should it be easy enough for me to cull out of the

+larger patch you posted?

+

+

+Sorry for the delay, had to finish some other concept yesterday (will be published soon).

+

+The attached patch adds

+

+    vacuum_group_delay_size = 10 (range 1-1000)

+    vacuum_group_delay_msec = 0  (range 0-1000)

+

+

+and does the sleeping via select(2). It does it only at the same places where Tom had done the usleep() in his hack, so I guess there is still some more to do besides the documentation, before it can be added to 7.4.1. But it should be enough to get some testing done.

+

+

+Jan

+

+--

+#======================================================================#

+# It's easier to get forgiveness for being wrong than for being right. #

+# Let's break this rule - forgive me.                                  #

+#================================================== JanWieck ( at ) Yahoo ( dot ) com #

+

+Index: src/backend/access/nbtree/nbtree.c

+===================================================================

+RCS file: /home/pgsql/CvsRoot/pgsql-server/src/backend/access/nbtree/nbtree.c,v

+retrieving revision 1.106

+diff -c -b -r1.106 nbtree.c

+*** src/backend/access/nbtree/nbtree.c	2003/09/29 23:40:26	1.106

+--- src/backend/access/nbtree/nbtree.c	2003/11/09 23:39:36

+***************

+*** 27,32 ****

+--- 27,40 ----

+  #include "storage/smgr.h"

+  

+  

++ /*

++  * Variables for vacuum_group_delay option (in commands/vacuumlazy.c)

++  */

++ extern int	vacuum_group_delay_size;	/* vacuum N pages */

++ extern int	vacuum_group_delay_msec;	/* then sleep M msec */

++ extern int	vacuum_group_delay_count;

++ 

++ 

+  /* Working state for btbuild and its callback */

+  typedef struct

+  {

+***************

+*** 610,615 ****

+--- 618,632 ----

+  

+  			CHECK_FOR_INTERRUPTS();

+  

++ 			if (vacuum_group_delay_msec > 0)

++ 			{

++ 				if (++vacuum_group_delay_count >= vacuum_group_delay_size)

++ 				{

++ 					PG_DELAY(vacuum_group_delay_msec);

++ 					vacuum_group_delay_count = 0;

++ 				}

++ 			}

++ 

+  			ndeletable = 0;

+  			page = BufferGetPage(buf);

+  			opaque = (BTPageOpaque) PageGetSpecialPointer(page);

+***************

+*** 736,741 ****

+--- 753,769 ----

+  		Buffer		buf;

+  		Page		page;

+  		BTPageOpaque opaque;

++ 

++ 		CHECK_FOR_INTERRUPTS();

++ 

++ 		if (vacuum_group_delay_msec > 0)

++ 		{

++ 			if (++vacuum_group_delay_count >= vacuum_group_delay_size)

++ 			{

++ 				PG_DELAY(vacuum_group_delay_msec);

++ 				vacuum_group_delay_count = 0;

++ 			}

++ 		}

+  

+  		buf = _bt_getbuf(rel, blkno, BT_READ);

+  		page = BufferGetPage(buf);

+Index: src/backend/commands/vacuumlazy.c

+===================================================================

+RCS file: /home/pgsql/CvsRoot/pgsql-server/src/backend/commands/vacuumlazy.c,v

+retrieving revision 1.32

+diff -c -b -r1.32 vacuumlazy.c

+*** src/backend/commands/vacuumlazy.c	2003/09/25 06:57:59	1.32

+--- src/backend/commands/vacuumlazy.c	2003/11/09 23:40:13

+***************

+*** 88,93 ****

+--- 88,100 ----

+  static TransactionId OldestXmin;

+  static TransactionId FreezeLimit;

+  

++ /*

++  * Variables for vacuum_group_delay option (in commands/vacuumlazy.c)

++  */

++ int	vacuum_group_delay_size = 10;	/* vacuum N pages */

++ int	vacuum_group_delay_msec = 0;	/* then sleep M msec */

++ int	vacuum_group_delay_count = 0;

++ 

+  

+  /* non-export function prototypes */

+  static void lazy_scan_heap(Relation onerel, LVRelStats *vacrelstats,

+***************

+*** 228,233 ****

+--- 235,249 ----

+  

+  		CHECK_FOR_INTERRUPTS();

+  

++ 		if (vacuum_group_delay_msec > 0)

++ 		{

++ 			if (++vacuum_group_delay_count >= vacuum_group_delay_size)

++ 			{

++ 				PG_DELAY(vacuum_group_delay_msec);

++ 				vacuum_group_delay_count = 0;

++ 			}

++ 		}

++ 

+  		/*

+  		 * If we are close to overrunning the available space for

+  		 * dead-tuple TIDs, pause and do a cycle of vacuuming before we

+***************

+*** 469,474 ****

+--- 485,499 ----

+  

+  		CHECK_FOR_INTERRUPTS();

+  

++ 		if (vacuum_group_delay_msec > 0)

++ 		{

++ 			if (++vacuum_group_delay_count >= vacuum_group_delay_size)

++ 			{

++ 				PG_DELAY(vacuum_group_delay_msec);

++ 				vacuum_group_delay_count = 0;

++ 			}

++ 		}

++ 

+  		tblk = ItemPointerGetBlockNumber(&vacrelstats->dead_tuples[tupindex]);

+  		buf = ReadBuffer(onerel, tblk);

+  		LockBufferForCleanup(buf);

+***************

+*** 799,804 ****

+--- 824,838 ----

+  					hastup;

+  

+  		CHECK_FOR_INTERRUPTS();

++ 

++ 		if (vacuum_group_delay_msec > 0)

++ 		{

++ 			if (++vacuum_group_delay_count >= vacuum_group_delay_size)

++ 			{

++ 				PG_DELAY(vacuum_group_delay_msec);

++ 				vacuum_group_delay_count = 0;

++ 			}

++ 		}

+  

+  		blkno--;

+  

+Index: src/backend/utils/misc/guc.c

+===================================================================

+RCS file: /home/pgsql/CvsRoot/pgsql-server/src/backend/utils/misc/guc.c,v

+retrieving revision 1.164.2.1

+diff -c -b -r1.164.2.1 guc.c

+*** src/backend/utils/misc/guc.c	2003/11/07 21:27:50	1.164.2.1

+--- src/backend/utils/misc/guc.c	2003/11/09 23:27:49

+***************

+*** 73,78 ****

+--- 73,80 ----

+  extern int	CommitDelay;

+  extern int	CommitSiblings;

+  extern char *preload_libraries_string;

++ extern int	vacuum_group_delay_size;

++ extern int	vacuum_group_delay_msec;

+  

+  #ifdef HAVE_SYSLOG

+  extern char *Syslog_facility;

+***************

+*** 1188,1193 ****

+--- 1190,1213 ----

+  		},

+  		&log_min_duration_statement,

+  		-1, -1, INT_MAX / 1000, NULL, NULL

++ 	},

++ 

++ 	{

++ 		{"vacuum_group_delay_msec", PGC_USERSET, RESOURCES,

++ 			gettext_noop("Sets VACUUM's delay in milliseconds between processing groups of pages."),

++ 			NULL

++ 		},

++ 		&vacuum_group_delay_msec,

++ 		0, 0, 1000, NULL, NULL

++ 	},

++ 

++ 	{

++ 		{"vacuum_group_delay_size", PGC_USERSET, RESOURCES,

++ 			gettext_noop("Sets VACUUM's group size for the vacuum_group_delay_msec option."),

++ 			NULL

++ 		},

++ 		&vacuum_group_delay_size,

++ 		10, 1, 1000, NULL, NULL

+  	},

+  

+  	/* End-of-list marker */

+Index: src/backend/utils/misc/postgresql.conf.sample

+===================================================================

+RCS file: /home/pgsql/CvsRoot/pgsql-server/src/backend/utils/misc/postgresql.conf.sample,v

+retrieving revision 1.92

+diff -c -b -r1.92 postgresql.conf.sample

+*** src/backend/utils/misc/postgresql.conf.sample	2003/10/08 03:49:38	1.92

+--- src/backend/utils/misc/postgresql.conf.sample	2003/11/09 23:04:21

+***************

+*** 69,74 ****

+--- 69,79 ----

+  #max_files_per_process = 1000	# min 25

+  #preload_libraries = ''

+  

++ # - Vacuum napping -

++ 

++ #vacuum_group_delay_size = 10	# range 1-1000 pages ; vacuum this many pages

++ #vacuum_group_delay_msec = 0	# range 0-1000 msec  ; then nap this long

++ 

+  

+  #---------------------------------------------------------------------------

+  # WRITE AHEAD LOG

+Index: src/include/miscadmin.h

+===================================================================

+RCS file: /home/pgsql/CvsRoot/pgsql-server/src/include/miscadmin.h,v

+retrieving revision 1.134

+diff -c -b -r1.134 miscadmin.h

+*** src/include/miscadmin.h	2003/09/24 18:54:01	1.134

+--- src/include/miscadmin.h	2003/11/09 23:02:03

+***************

+*** 96,101 ****

+--- 96,111 ----

+  		CritSectionCount--; \

+  	} while(0)

+  

++ /*

++  * Macro using select(2) to nap for milliseconds

++  */

++ #define PG_DELAY(_msec) \

++ { \

++     struct timeval _delay; \

++ 	_delay.tv_sec  = (_msec) / 1000; \

++ 	_delay.tv_usec = ((_msec) % 1000) * 1000; \

++ 	(void) select(0, NULL, NULL, NULL, &_delay);\

++ }

+  

+  /*****************************************************************************

+   *	  globals.h --															 *

diff --git a/dev-db/postgresql/files/postgresql-8.0.7-gentoo.patch b/dev-db/postgresql/files/postgresql-8.0.7-gentoo.patch
new file mode 100644
index 000000000000..d922fabed2e4
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql-8.0.7-gentoo.patch
@@ -0,0 +1,39 @@
+diff -Naru postgresql-8.0.4.org/src/interfaces/Makefile postgresql-8.0.4/src/interfaces/Makefile
+--- postgresql-8.0.4.org/src/interfaces/Makefile	2004-04-20 01:33:51.000000000 +0100
++++ postgresql-8.0.4/src/interfaces/Makefile	2005-05-09 21:59:15.000000000 +0100
+@@ -12,7 +12,7 @@
+ top_builddir = ../..
+ include $(top_builddir)/src/Makefile.global
+ 
+-DIRS := libpq ecpg 
++DIRS := ecpg 
+ 
+ ALLDIRS := $(DIRS) 
+ 
+diff -Naru postgresql-8.0.4.org/src/Makefile postgresql-8.0.4/src/Makefile
+--- postgresql-8.0.4.org/src/Makefile	2005-01-13 18:23:21.000000000 +0000
++++ postgresql-8.0.4/src/Makefile	2005-05-09 21:59:54.000000000 +0100
+@@ -18,7 +18,6 @@
+ 	$(MAKE) -C timezone $@
+ 	$(MAKE) -C backend $@
+ 	$(MAKE) -C backend/utils/mb/conversion_procs $@
+-	$(MAKE) -C include $@
+ 	$(MAKE) -C interfaces $@
+ 	$(MAKE) -C bin $@
+ 	$(MAKE) -C pl $@
+@@ -47,7 +46,6 @@
+ 	$(MAKE) -C port $@
+ 	$(MAKE) -C timezone $@
+ 	$(MAKE) -C backend $@
+-	$(MAKE) -C include $@
+ 	$(MAKE) -C interfaces $@
+ 	$(MAKE) -C bin $@
+ 	$(MAKE) -C pl $@
+@@ -61,7 +59,6 @@
+ 	-$(MAKE) -C port $@
+ 	-$(MAKE) -C timezone $@
+ 	-$(MAKE) -C backend $@
+-	-$(MAKE) -C include $@
+ 	-$(MAKE) -C interfaces $@
+ 	-$(MAKE) -C bin $@
+ 	-$(MAKE) -C pl $@
diff --git a/dev-db/postgresql/files/postgresql-8.0.7-sh.patch b/dev-db/postgresql/files/postgresql-8.0.7-sh.patch
new file mode 100644
index 000000000000..fc59d52af0e8
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql-8.0.7-sh.patch
@@ -0,0 +1,34 @@
+--- src/include/storage/s_lock.h~	2005-01-01 07:03:42.000000000 +0900
++++ src/include/storage/s_lock.h	2005-08-17 23:09:19.000000000 +0900
+@@ -239,6 +239,31 @@
+ #endif	 /* __s390__ || __s390x__ */
+ 
+ 
++#if defined(__sh__)
++#define HAS_TEST_AND_SET
++
++typedef unsigned char slock_t;
++
++#define TAS(lock) tas(lock)
++
++static __inline__ int
++tas(volatile slock_t *lock)
++{
++	register int _res = 1;
++
++	__asm__ __volatile__(
++		"tas.b	@%1\n\t"
++		"movt	%0\n\t"
++		"xor	#1,%0"
++:		"=z"(_res)
++:		"r"(lock)
++:		"t","memory");
++	return _res;
++}
++
++#endif	 /* __sh__ */
++
++
+ #if defined(__sparc__)
+ #define HAS_TEST_AND_SET
+ 
diff --git a/dev-db/postgresql/files/postgresql.conf-7.4.12 b/dev-db/postgresql/files/postgresql.conf-7.4.12
new file mode 100644
index 000000000000..e8dab3e4c827
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql.conf-7.4.12
@@ -0,0 +1,14 @@
+# PostgreSQL's Database Directory
+PGDATA=/var/lib/postgresql/data
+
+# Logfile path: (NOTE: This must be uid/gid owned by the value of $PGUSER!)
+PGLOG=/var/lib/postgresql/data/postgresql.log
+
+# Run the PostgreSQL user as:
+PGUSER=postgres
+
+# Extra options to run postmaster with.
+# If you want to enable TCP/IP for PostgreSQL, add -i to the following:
+# PGOPTS="-N 1024 -B 2048 -i"
+PGOPTS=""
+
diff --git a/dev-db/postgresql/files/postgresql.conf-8.0.7 b/dev-db/postgresql/files/postgresql.conf-8.0.7
new file mode 100644
index 000000000000..e8dab3e4c827
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql.conf-8.0.7
@@ -0,0 +1,14 @@
+# PostgreSQL's Database Directory
+PGDATA=/var/lib/postgresql/data
+
+# Logfile path: (NOTE: This must be uid/gid owned by the value of $PGUSER!)
+PGLOG=/var/lib/postgresql/data/postgresql.log
+
+# Run the PostgreSQL user as:
+PGUSER=postgres
+
+# Extra options to run postmaster with.
+# If you want to enable TCP/IP for PostgreSQL, add -i to the following:
+# PGOPTS="-N 1024 -B 2048 -i"
+PGOPTS=""
+
diff --git a/dev-db/postgresql/files/postgresql.init-7.3.14 b/dev-db/postgresql/files/postgresql.init-7.3.14
new file mode 100644
index 000000000000..5e36a8051d5b
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql.init-7.3.14
@@ -0,0 +1,63 @@
+#!/sbin/runscript
+# Copyright 1999-2004 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/files/postgresql.init-7.3.14,v 1.1 2006/02/15 12:55:05 nakano Exp $
+
+opts="${opts} reload"
+
+depend() {
+	use net
+}
+
+checkconfig() {
+	if [ ! -d $PGDATA ]; then
+		eerror "directory not found: $PGDATA"
+		eerror "You should create PGDATA directory first."
+		return 1
+	fi
+}
+
+start() {
+	checkconfig || return 1
+
+	ebegin "Starting PostgreSQL"
+	if [ -f $PGDATA/postmaster.pid ]; then
+		rm $PGDATA/postmaster.pid
+	fi
+	su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l '$PGLOG' -o '$PGOPTS'"
+
+	while :
+	do
+		cnt=$(($cnt + 1))
+		if [ -f "$PGDATA/postmaster.pid" ]; then
+			ret=0
+			break
+		fi
+
+		if [ $cnt -eq 30 ]; then
+			eerror "Please see log file: $PGLOG"
+			ret=1
+			break
+		fi
+		sleep 1
+	done
+	eend $ret
+}
+
+stop() {
+	ebegin "Stopping PostgreSQL"
+	su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast"
+	eend $?
+}
+
+svc_restart() {
+	ebegin "Restarting PostgreSQL"
+	su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m fast -l '$PGLOG' -o '$PGOPTS'"
+	eend $?
+}
+
+reload() {
+	ebegin "Reloading PostgreSQL configuration"
+	su - $PGUSER -c "/usr/bin/pg_ctl reload -D '$PGDATA' -s"
+	eend $?
+}
diff --git a/dev-db/postgresql/files/postgresql.init-7.4.12 b/dev-db/postgresql/files/postgresql.init-7.4.12
new file mode 100644
index 000000000000..114ff097f2f6
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql.init-7.4.12
@@ -0,0 +1,63 @@
+#!/sbin/runscript
+# Copyright 1999-2004 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/files/postgresql.init-7.4.12,v 1.1 2006/02/15 12:55:05 nakano Exp $
+
+opts="${opts} reload"
+
+depend() {
+	use net
+}
+
+checkconfig() {
+	if [ ! -d $PGDATA ]; then
+		eerror "directory not found: $PGDATA"
+		eerror "You should create PGDATA directory first."
+		return 1
+	fi
+}
+
+start() {
+	checkconfig || return 1
+
+	ebegin "Starting PostgreSQL"
+	if [ -f $PGDATA/postmaster.pid ]; then
+		rm $PGDATA/postmaster.pid
+	fi
+	su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l '$PGLOG' -o '$PGOPTS'"
+
+	while :
+	do
+		cnt=$(($cnt + 1))
+		if [ -f "$PGDATA/postmaster.pid" ]; then
+			ret=0
+			break
+		fi
+
+		if [ $cnt -eq 30 ]; then
+			eerror "Please see log file: $PGLOG"
+			ret=1
+			break
+		fi
+		sleep 1
+	done
+	eend $ret
+}
+
+stop() {
+	ebegin "Stopping PostgreSQL"
+	su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast"
+	eend $?
+}
+
+svc_restart() {
+	ebegin "Restarting PostgreSQL"
+	su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m fast -l '$PGLOG' -o '$PGOPTS'"
+	eend $?
+}
+
+reload() {
+	ebegin "Reloading PostgreSQL configuration"
+	su - $PGUSER -c "/usr/bin/pg_ctl reload -D '$PGDATA' -s"
+	eend $?
+}
diff --git a/dev-db/postgresql/files/postgresql.init-8.0.7 b/dev-db/postgresql/files/postgresql.init-8.0.7
new file mode 100644
index 000000000000..e7a4a505617e
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql.init-8.0.7
@@ -0,0 +1,63 @@
+#!/sbin/runscript
+# Copyright 1999-2004 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/files/postgresql.init-8.0.7,v 1.1 2006/02/15 12:55:05 nakano Exp $
+
+opts="${opts} reload"
+
+depend() {
+	use net
+}
+
+checkconfig() {
+	if [ ! -d $PGDATA ]; then
+		eerror "directory not found: $PGDATA"
+		eerror "You should create PGDATA directory first."
+		return 1
+	fi
+}
+
+start() {
+	checkconfig || return 1
+
+	ebegin "Starting PostgreSQL"
+	if [ -f $PGDATA/postmaster.pid ]; then
+		rm $PGDATA/postmaster.pid
+	fi
+	su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l '$PGLOG' -o '$PGOPTS'"
+
+	while :
+	do
+		cnt=$(($cnt + 1))
+		if [ -f "$PGDATA/postmaster.pid" ]; then
+			ret=0
+			break
+		fi
+
+		if [ $cnt -eq 30 ]; then
+			eerror "Please see log file: $PGLOG"
+			ret=1
+			break
+		fi
+		sleep 1
+	done
+	eend $ret
+}
+
+stop() {
+	ebegin "Stopping PostgreSQL"
+	su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast"
+	eend $?
+}
+
+svc_restart() {
+	ebegin "Restarting PostgreSQL"
+	su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m fast -l '$PGLOG' -o '$PGOPTS'"
+	eend $?
+}
+
+reload() {
+	ebegin "Reloading PostgreSQL configuration"
+	su - $PGUSER -c "/usr/bin/pg_ctl reload -D '$PGDATA' -s"
+	eend $?
+}
diff --git a/dev-db/postgresql/postgresql-7.3.14.ebuild b/dev-db/postgresql/postgresql-7.3.14.ebuild
new file mode 100644
index 000000000000..d7ff874d9516
--- /dev/null
+++ b/dev-db/postgresql/postgresql-7.3.14.ebuild
@@ -0,0 +1,246 @@
+# Copyright 1999-2006 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/postgresql-7.3.14.ebuild,v 1.1 2006/02/15 12:55:05 nakano Exp $
+
+inherit eutils gnuconfig flag-o-matic java-pkg multilib
+
+DESCRIPTION="sophisticated Object-Relational DBMS"
+
+HOMEPAGE="http://www.postgresql.org/"
+SRC_URI="mirror://postgresql/source/v${PV}/${PN}-base-${PV}.tar.bz2
+	mirror://postgresql/source/v${PV}/${PN}-opt-${PV}.tar.bz2
+	doc? ( mirror://postgresql/source/v${PV}/${PN}-docs-${PV}.tar.bz2 )"
+
+LICENSE="POSTGRESQL"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~hppa ~ia64 ~mips ~ppc ~sparc ~x86"
+IUSE="doc java libg++ nls pam perl python readline ssl tcltk zlib threads selinux"
+
+DEPEND="virtual/libc
+	=dev-db/libpq-7.3.14*
+	sys-devel/autoconf
+	>=sys-libs/ncurses-5.2
+	zlib? ( >=sys-libs/zlib-1.1.3 )
+	readline? ( >=sys-libs/readline-4.1 )
+	tcltk? ( >=dev-lang/tcl-8 >=dev-lang/tk-8.3.3-r1 )
+	perl? ( >=dev-lang/perl-5.6.1-r2 )
+	python? ( >=dev-lang/python-2.2 dev-python/egenix-mx-base )
+	java? ( >=virtual/jdk-1.3 >=dev-java/ant-1.3
+		dev-java/java-config )
+	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
+	nls? ( sys-devel/gettext )"
+# java dep workaround for portage bug
+# x86? ( java? ( =dev-java/sun-jdk-1.3* >=dev-java/ant-1.3 ) )
+RDEPEND="virtual/libc
+	=dev-db/libpq-7.3.14*
+	zlib? ( >=sys-libs/zlib-1.1.3 )
+	tcltk? ( >=dev-lang/tcl-8 )
+	perl? ( >=dev-lang/perl-5.6.1-r2 )
+	python? ( >=dev-lang/python-2.2 )
+	java? ( >=virtual/jdk-1.3 )
+	selinux? ( sec-policy/selinux-postgresql )
+	ssl? ( >=dev-libs/openssl-0.9.6-r1 )"
+
+PG_DIR="/var/lib/postgresql"
+
+pkg_setup() {
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
+		PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
+		if [ ${PG_MAJOR} -lt 7 ] || [ ${PG_MAJOR} -eq 7 -a ${PG_MINOR} -lt 3 ] ; then
+			eerror "Postgres ${PV} cannot upgrade your existing databases, you must"
+			eerror "use pg_dump to export your existing databases to a file, and then"
+			eerror "pg_restore to import them when you have upgraded completely."
+			eerror "You must remove your entire database directory to continue."
+			eerror "(database directory = ${PG_DIR})."
+			exit 1
+		fi
+	fi
+	enewgroup postgres 70 \
+		|| die "problem adding group postgres"
+	enewuser postgres 70 /bin/bash /var/lib/postgresql postgres \
+		|| die "problem adding user postgres"
+}
+
+check_java_config() {
+	JDKHOME="`java-config --jdk-home`"
+	if [[ -z "${JDKHOME}" || ! -d "${JDKHOME}" ]]; then
+		NOJDKERROR="You need to use java-config to set your JVM to a JDK!"
+		eerror "${NOJDKERROR}"
+		die "${NOJDKERROR}"
+	fi
+}
+
+src_unpack() {
+	unpack ${A} || die
+	epatch ${FILESDIR}/${P}-gentoo.patch
+}
+
+src_compile() {
+	filter-flags -ffast-math
+
+	if use java; then
+		check_java_config
+	fi
+
+	local myconf
+	use tcltk && myconf="--with-tcl"
+	use python && myconf="$myconf --with-python"
+	use perl && myconf="$myconf --with-perl"
+	use java && myconf="$myconf --with-java"
+	use ssl && myconf="$myconf --with-openssl"
+	use nls && myconf="$myconf --enable-nls"
+	use libg++ && myconf="$myconf --with-CXX"
+	use pam && myconf="$myconf --with-pam"
+	use readline || myconf="$myconf --without-readline"
+	use zlib || myconf="$myconf --without-zlib"
+	use threads && myconf="$myconf --enable-thread-safety"
+
+	# these are the only working CFLAGS I could get on ppc, so locking them
+	# down, anything more aggressive fails (i.e. -mcpu or -Ox)
+	# Gerk - Nov 26, 2002
+	use ppc && CFLAGS="-pipe -fsigned-char"
+
+	# Detect mips systems properly
+	gnuconfig_update
+
+	./configure --prefix=/usr \
+		--mandir=/usr/share/man \
+		--host=${CHOST} \
+		--docdir=/usr/share/doc/${PF} \
+		--libdir=/usr/$(get_libdir) \
+		--includedir=/usr/include/postgresql/pgsql \
+		--enable-depend \
+		--with-maxbackends=1024 \
+		$myconf || die
+
+	make || die
+	cd contrib
+	make || die
+}
+
+src_install() {
+	if use perl; then
+		mv ${S}/src/pl/plperl/Makefile ${S}/src/pl/plperl/Makefile_orig
+		sed -e "s:(INST_DYNAMIC) /usr/lib:(INST_DYNAMIC) ${D}/usr/$(get_libdir):" \
+			${S}/src/pl/plperl/Makefile_orig > ${S}/src/pl/plperl/Makefile
+		mv ${S}/src/pl/plperl/GNUmakefile ${S}/src/pl/plperl/GNUmakefile_orig
+		sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \
+			${S}/src/pl/plperl/GNUmakefile_orig > ${S}/src/pl/plperl/GNUmakefile
+	fi
+
+	make DESTDIR=${D} includedir_server=/usr/include/postgresql/server \
+		includedir_internal=/usr/include/postgresql/internal \
+		LIBDIR=${D}/usr/$(get_libdir) \
+		python_moduleexecdir="${python_execprefix}/$(get_libdir)/python${python_version}/site-packages" \
+		install || die
+	make DESTDIR=${D} includedir_server=/usr/include/postgresql/server includedir_internal=/usr/include/postgresql/internal install-all-headers || die
+	cd ${S}/contrib
+	make DESTDIR=${D} LIBDIR=${D}/usr/$(get_libdir) install || die
+	cd ${S}
+	dodoc COPYRIGHT HISTORY INSTALL README register.txt
+	dodoc contrib/adddepend/*
+
+	if use java; then
+		# we need to remove jar file after dojar; otherwise two same jar
+		# file are installed.
+		java-pkg_dojar ${D}/usr/share/postgresql/java/postgresql.jar
+		rm ${D}/usr/share/postgresql/java/postgresql.jar
+	fi
+
+	# backward compatibility
+	for i in ${D}/usr/include/postgresql/pgsql/*
+	do
+		ln -s ${i} ${D}/usr/include/
+	done
+
+	cd ${S}/doc
+	dodoc FAQ* README.* TODO bug.template
+	if use doc; then
+		cd ${S}/doc
+		docinto FAQ_html
+		dodoc src/FAQ/*
+		docinto sgml
+		dodoc src/sgml/*.{sgml,dsl}
+		docinto sgml/ref
+		dodoc src/sgml/ref/*.sgml
+		docinto TODO.detail
+		dodoc TODO.detail/*
+	fi
+
+	cd ${S}
+	exeinto /etc/init.d/
+	newexe ${FILESDIR}/postgresql.init-${PV} postgresql || die
+
+	insinto /etc/conf.d/
+	newins ${FILESDIR}/postgresql.conf postgresql || die
+
+	keepdir /var/lib/postgresql
+}
+
+pkg_postinst() {
+	einfo "Execute the following command"
+	einfo "emerge --config =${PF}"
+	einfo "to setup the initial database environment."
+	einfo ""
+	einfo "Make sure the postgres user in /etc/passwd has an account setup with /bin/bash as the shell"
+}
+
+pkg_config() {
+	einfo "Creating the data directory ..."
+	mkdir -p ${PG_DIR}/data
+	chown -Rf postgres:postgres ${PG_DIR}
+	chmod 700 ${PG_DIR}/data
+
+	einfo "Initializing the database ..."
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
+		PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
+		if [ ${PG_MAJOR} -lt 7 ] || [ ${PG_MAJOR} -eq 7 -a ${PG_MINOR} -lt 3 ] ; then
+			eerror "Postgres ${PV} cannot upgrade your existing databases."
+			eerror "You must remove your entire database directory to continue."
+			eerror "(database directory = ${PG_DIR})."
+			exit 1
+		else
+			einfon "A postgres data directory already exists from version "; cat ${PG_DIR}/data/PG_VERSION
+			einfo "Read the documentation to check how to upgrade to version ${PV}."
+		fi
+	else
+		# On hppa, postgresql need way more than the default sem index and shmmax
+		if [ "${ARCH}" = "hppa" ]; then
+			SEM_IDX_MIN=1024
+			SHMMAX_MIN=100000000
+			SEM_IDX=`sysctl kernel.sem | awk '{ print $6 }'`
+			if [ $SEM_IDX -lt ${SEM_IDX_MIN} ]; then
+				eerror "The last value of /proc/sys/kernel/sem is too low for postgresql to run"
+				eerror "Temporary setting this value to ${SEM_IDX_MIN} while creating the initial database."
+				cat /proc/sys/kernel/sem | sed -e "s/\t${SEM_IDX}/\t${SEM_IDX_MIN}/" > /proc/sys/kernel/sem
+			fi
+		fi
+		su postgres -c "/usr/bin/initdb --pgdata ${PG_DIR}/data"
+
+		if [ "${ARCH}" = "hppa" ]; then
+			if [ ! `sysctl kernel.sem | awk '{ print $6 }'` -eq ${SEM_IDX} ] ; then
+				cat /proc/sys/kernel/sem | sed -e "s/\t${SEM_IDX_MIN}/\t${SEM_IDX}/" > /proc/sys/kernel/sem
+				ewarn "Restoring the sem idx value to the previous value"
+				ewarn "Please edit the last value of kernel.sem in /etc/sysctl.conf"
+				ewarn "and set it to at least ${SEM_IDX_MIN}"
+			fi
+
+			if [ `sysctl kernel.shmmax | awk '{ print $3 }'` -lt ${SHMMAX_MIN} ]; then
+				eerror "The current value of /proc/sys/kernel/shmmax is too low"
+				eerror "for postgresql to run. Please edit /etc/sysctl.conf and set"
+				eerror "this value to at least ${SHMMAX_MIN}."
+
+			fi
+		fi
+
+		einfo "If you are upgrading from a pre-7.3 version of PostgreSQL, please read"
+		einfo "the README.adddepend file for information on how to properly migrate"
+		einfo "all serial columns, unique keys and foreign keys to this version."
+
+		einfo ""
+		einfo "You can use /etc/init.d/postgresql script to run PostgreSQL instead of pg_ctl."
+		einfo ""
+	fi
+}
diff --git a/dev-db/postgresql/postgresql-7.4.12.ebuild b/dev-db/postgresql/postgresql-7.4.12.ebuild
new file mode 100644
index 000000000000..7b6b371d715f
--- /dev/null
+++ b/dev-db/postgresql/postgresql-7.4.12.ebuild
@@ -0,0 +1,311 @@
+# Copyright 1999-2006 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/postgresql-7.4.12.ebuild,v 1.1 2006/02/15 12:55:05 nakano Exp $
+
+inherit eutils gnuconfig flag-o-matic java-pkg multilib toolchain-funcs
+
+DESCRIPTION="sophisticated Object-Relational DBMS."
+HOMEPAGE="http://www.postgresql.org/"
+P_HIERPG="hier-Pg7.4-0.5.3"
+SRC_URI="mirror://postgresql/source/v${PV}/${PN}-base-${PV}.tar.bz2
+	mirror://postgresql/source/v${PV}/${PN}-opt-${PV}.tar.bz2
+	doc? ( mirror://postgresql/source/v${PV}/${PN}-docs-${PV}.tar.bz2 )
+	pg-hier? ( ftp://gborg.postgresql.org/pub/hierpg/stable/${P_HIERPG}.tar.gz )"
+
+LICENSE="POSTGRESQL"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~s390 ~sh ~sparc ~x86"
+IUSE="ssl nls java python tcltk perl libg++ pam readline zlib doc pg-hier pg-vacuumdelay pg-intdatetime threads xml2 selinux"
+
+DEPEND="virtual/libc
+	=dev-db/libpq-7.4.12*
+	sys-devel/autoconf
+	>=sys-libs/ncurses-5.2
+	>=sys-devel/bison-1.875
+	zlib? ( >=sys-libs/zlib-1.1.3 )
+	readline? ( >=sys-libs/readline-4.1 )
+	tcltk? ( >=dev-lang/tcl-8 >=dev-lang/tk-8.3.3-r1 )
+	perl? ( >=dev-lang/perl-5.6.1-r2 )
+	python? ( >=dev-lang/python-2.2 dev-python/egenix-mx-base )
+	java? ( >=virtual/jdk-1.3 >=dev-java/ant-1.3
+		dev-java/java-config )
+	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
+	nls? ( sys-devel/gettext )
+	xml2? ( dev-libs/libxml2 dev-libs/libxslt dev-util/pkgconfig )"
+# java dep workaround for portage bug
+# x86? ( java? ( =dev-java/sun-jdk-1.3* >=dev-java/ant-1.3 ) )
+RDEPEND="virtual/libc
+	=dev-db/libpq-7.4.12*
+	zlib? ( >=sys-libs/zlib-1.1.3 )
+	tcltk? ( >=dev-lang/tcl-8 )
+	perl? ( >=dev-lang/perl-5.6.1-r2 )
+	python? ( >=dev-lang/python-2.2 )
+	java? ( >=virtual/jdk-1.3 )
+	selinux? ( sec-policy/selinux-postgresql )
+	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
+	xml2? ( dev-libs/libxml2 dev-libs/libxslt )"
+
+PG_DIR="/var/lib/postgresql"
+MAX_CONNECTIONS=1024
+
+pkg_setup() {
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
+		PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
+		if [ ${PG_MAJOR} -lt 7 ] || [ ${PG_MAJOR} -eq 7 -a ${PG_MINOR} -lt 4 ] ; then
+			eerror "Postgres ${PV} cannot upgrade your existing databases, you must"
+			eerror "use pg_dump to export your existing databases to a file, and then"
+			eerror "pg_restore to import them when you have upgraded completely."
+			eerror "You must remove your entire database directory to continue."
+			eerror "(database directory = ${PG_DIR})."
+			exit 1
+		fi
+	fi
+	enewgroup postgres 70 \
+		|| die "problem adding group postgres"
+	enewuser postgres 70 /bin/bash /var/lib/postgresql postgres \
+		|| die "problem adding user postgres"
+}
+
+check_java_config() {
+	JDKHOME="`java-config --jdk-home`"
+	if [[ -z "${JDKHOME}" || ! -d "${JDKHOME}" ]]; then
+		NOJDKERROR="You need to use java-config to set your JVM to a JDK!"
+		eerror "${NOJDKERROR}"
+		die "${NOJDKERROR}"
+	fi
+}
+
+src_unpack() {
+	unpack ${A} || die
+	epatch ${FILESDIR}/${P}-gentoo.patch
+
+	if use pg-hier; then
+		cd ${S} || die
+		epatch ${WORKDIR}/${P_HIERPG}.diff
+	fi
+
+	if use pg-vacuumdelay; then
+		cd ${S} || die
+		epatch ${FILESDIR}/${P}-vacuum-delay.patch
+	fi
+
+	if [ "${ARCH}" = "hppa" ]
+	then
+		cd ${S}
+		epatch ${FILESDIR}/${P}-hppa-testandset.patch
+	fi
+}
+
+src_compile() {
+	filter-flags -ffast-math
+
+	if use java; then
+		check_java_config
+	fi
+
+	local myconf
+	use tcltk && myconf="--with-tcl"
+	use python && myconf="$myconf --with-python"
+	use perl && myconf="$myconf --with-perl"
+	use java && myconf="$myconf --with-java"
+	use ssl && myconf="$myconf --with-openssl"
+	use nls && myconf="$myconf --enable-nls"
+	use libg++ && myconf="$myconf --with-CXX"
+	use pam && myconf="$myconf --with-pam"
+	use readline || myconf="$myconf --without-readline"
+	use zlib || myconf="$myconf --without-zlib"
+	use pg-intdatetime && myconf="$myconf --enable-integer-datetimes"
+	use threads && myconf="$myconf --enable-thread-safety"
+
+	# these are the only working CFLAGS I could get on ppc, so locking them
+	# down, anything more aggressive fails (i.e. -mcpu or -Ox)
+	# Gerk - Nov 26, 2002
+	use ppc && CFLAGS="-pipe -fsigned-char"
+	use xml2 && CFLAGS="${CFLAGS} $(pkg-config --cflags libxml-2.0)"
+	use xml2 && LIBS="${LIBS} $(pkg-config --libs libxml-2.0)"
+
+	# Detect mips systems properly
+	gnuconfig_update
+
+	./configure --prefix=/usr \
+		--mandir=/usr/share/man \
+		--host=${CHOST} \
+		--docdir=/usr/share/doc/${PF} \
+		--libdir=/usr/$(get_libdir) \
+		--includedir=/usr/include/postgresql/pgsql \
+		--enable-depend \
+		--with-maxbackends=${MAX_CONNECTIONS} \
+		$myconf || die
+
+	make LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die
+	cd contrib
+	make LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die
+	if use xml2; then
+		make -C xml LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die
+	fi
+}
+
+src_install() {
+	if use perl; then
+		mv ${S}/src/pl/plperl/Makefile ${S}/src/pl/plperl/Makefile_orig
+		sed -e "s:(INST_DYNAMIC) /usr/lib:(INST_DYNAMIC) ${D}/usr/lib:" \
+			${S}/src/pl/plperl/Makefile_orig > ${S}/src/pl/plperl/Makefile
+		mv ${S}/src/pl/plperl/GNUmakefile ${S}/src/pl/plperl/GNUmakefile_orig
+		sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \
+			${S}/src/pl/plperl/GNUmakefile_orig > ${S}/src/pl/plperl/GNUmakefile
+	fi
+
+	make DESTDIR=${D} includedir_server=/usr/include/postgresql/server includedir_internal=/usr/include/postgresql/internal LIBDIR=${D}/usr/lib install || die
+	make DESTDIR=${D} includedir_server=/usr/include/postgresql/server includedir_internal=/usr/include/postgresql/internal install-all-headers || die
+	cd ${S}/contrib
+	make DESTDIR=${D} LIBDIR=${D}/usr/lib install || die
+	if use xml2; then
+		make -C xml DESTDIR=${D} IBDIR=${D}/usr/lib install || die
+	fi
+	cd ${S}
+	if use pg-hier; then
+		dodoc ${WORKDIR}/README-${P_HIERPG}.html
+	fi
+	dodoc README HISTORY COPYRIGHT INSTALL
+	dodoc contrib/adddepend/*
+
+	exeinto /usr/bin
+
+	if use java; then
+		# we need to remove jar file after dojar; otherwise two same jar
+		# file are installed.
+		java-pkg_dojar ${D}/usr/share/postgresql/java/postgresql.jar || die
+		rm ${D}/usr/share/postgresql/java/postgresql.jar
+		java-pkg_dojar ${D}/usr/share/postgresql/java/postgresql-examples.jar || die
+		rm ${D}/usr/share/postgresql/java/postgresql-examples.jar
+	fi
+
+	# backward compatibility
+	for i in ${D}/usr/include/postgresql/pgsql/*
+	do
+		ln -s ${i} ${D}/usr/include/
+	done
+
+	cd ${S}/doc
+	dodoc FAQ* README.* TODO bug.template
+	if use doc; then
+		cd ${S}/doc
+		docinto FAQ_html
+		dodoc src/FAQ/*
+		docinto sgml
+		dodoc src/sgml/*.{sgml,dsl}
+		docinto sgml/ref
+		dodoc src/sgml/ref/*.sgml
+		docinto TODO.detail
+		dodoc TODO.detail/*
+	fi
+
+	cd ${S}
+	exeinto /etc/init.d/
+	newexe ${FILESDIR}/postgresql.init-${PV} postgresql || die
+	newexe ${FILESDIR}/pg_autovacuum.init-${PV} pg_autovacuum || die
+	dosed "s:___DOCDIR___:/usr/share/doc/${PF}:" /etc/init.d/pg_autovacuum
+
+	insinto /etc/conf.d/
+	newins ${FILESDIR}/postgresql.conf-${PV} postgresql || die
+	newins ${FILESDIR}/pg_autovacuum.conf-${PV} pg_autovacuum || die
+}
+
+pkg_postinst() {
+	einfo "Make sure the postgres user in /etc/passwd has an account setup with /bin/bash as the shell"
+
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
+		PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
+		if [ ${PG_MAJOR} -lt 7 ] || [ ${PG_MAJOR} -eq 7 -a ${PG_MINOR} -eq 4 ] ; then
+			ewarn ""
+			ewarn "If you are upgrading from PostgreSQL 7.4 or 7.4.1, it is strongly recommended"
+			ewarn "that you read the release notes concerning changes to the system catalogs."
+			ewarn "You can run 7.4.2 without rerunning initdb, however you may still experience"
+			ewarn "random crashes due to an error in pg_statistic."
+			ewarn ""
+			ewarn "If you prefer not to re-initdb your installation, the release notes contain"
+			ewarn "a procedure for manually correcting the problem."
+			ewarn ""
+		fi
+
+		if use pg-hier; then
+			ewarn ""
+			ewarn "REQUIRED!! After installing patched PostgreSQL by pg-hier"
+			ewarn "it is required to run 'initdb'. Without this Pg will fail "
+			ewarn "with error "
+			ewarn "ERROR: did not find '}' at end of input node. "
+			ewarn ""
+		fi
+	else
+		einfo ""
+		einfo "Execute the following command"
+		einfo "emerge --config =${PF}"
+		einfo "to setup the initial database environment."
+		einfo ""
+	fi
+
+	einfo ""
+	einfo "Python modules was removed from PostgreSQL package."
+	einfo "If you need it, please run \"emerge dev-db/pygresql\"."
+	einfo ""
+}
+
+pkg_config() {
+	einfo "Creating the data directory ..."
+	mkdir -p ${PG_DIR}/data
+	chown -Rf postgres:postgres ${PG_DIR}
+	chmod 700 ${PG_DIR}/data
+
+	einfo "Initializing the database ..."
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
+		PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
+		if [ ${PG_MAJOR} -lt 7 ] || [ ${PG_MAJOR} -eq 7 -a ${PG_MINOR} -lt 3 ] ; then
+			eerror "Postgres ${PV} cannot upgrade your existing databases."
+			eerror "You must remove your entire database directory to continue."
+			eerror "(database directory = ${PG_DIR})."
+			exit 1
+		else
+			einfon "A postgres data directory already exists from version "; cat ${PG_DIR}/data/PG_VERSION
+			einfo "Read the documentation to check how to upgrade to version ${PV}."
+		fi
+	else
+		local SEM=`sysctl -n kernel.sem | cut -f-3`
+		local SEMMNI=`sysctl -n kernel.sem | cut -f4`
+		local SEMMNI_MIN=`expr \( ${MAX_CONNECTIONS} + 15 \) / 16`
+		local SHMMAX=`sysctl -n kernel.shmmax`
+		local SHMMAX_MIN=`expr 250000 + 30600 \* ${MAX_CONNECTIONS}`
+
+		if [ ${SEMMNI} -lt ${SEMMNI_MIN} ]; then
+			eerror "The current value of SEMMNI is too low"
+			eerror "for postgresql to run ${MAX_CONNECTIONS} connections"
+			eerror "Temporary setting this value to ${SEMMNI_MIN} while creating the initial database."
+			echo ${SEM} ${SEMMNI_MIN} > /proc/sys/kernel/sem
+		fi
+		su postgres -c "/usr/bin/initdb --pgdata ${PG_DIR}/data"
+
+		if [ ! `sysctl -n kernel.sem | cut -f4` -eq ${SEMMNI} ] ; then
+			echo ${SEM} ${SEMMNI} > /proc/sys/kernel/sem
+			ewarn "Restoring the SEMMNI value to the previous value"
+			ewarn "Please edit the last value of kernel.sem in /etc/sysctl.conf"
+			ewarn "and set it to at least ${SEMMNI_MIN}"
+			ewarn ""
+			ewarn "  kernel.sem = ${SEM} ${SEMMNI_MIN}"
+			ewarn ""
+		fi
+
+		if [ ${SHMMAX} -lt ${SHMMAX_MIN} ]; then
+			eerror "The current value of SHMMAX is too low for postgresql to run."
+			eerror "Please edit /etc/sysctl.conf and set this value to at least ${SHMMAX_MIN}."
+			eerror ""
+			eerror "  kernel.shmmax = ${SHMMAX_MIN}"
+			eerror ""
+
+		fi
+		einfo ""
+		einfo "You can use /etc/init.d/postgresql script to run PostgreSQL instead of pg_ctl."
+		einfo ""
+	fi
+}
diff --git a/dev-db/postgresql/postgresql-8.0.7.ebuild b/dev-db/postgresql/postgresql-8.0.7.ebuild
new file mode 100644
index 000000000000..525e0befadf0
--- /dev/null
+++ b/dev-db/postgresql/postgresql-8.0.7.ebuild
@@ -0,0 +1,230 @@
+# Copyright 1999-2006 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/postgresql-8.0.7.ebuild,v 1.1 2006/02/15 12:55:05 nakano Exp $
+
+inherit eutils gnuconfig flag-o-matic multilib toolchain-funcs
+
+DESCRIPTION="sophisticated Object-Relational DBMS."
+HOMEPAGE="http://www.postgresql.org/"
+P_HIERPG="hier-Pg8.0.1-0.5.4"
+MY_PV=${PV/_/}
+MY_P=${PN}-${MY_PV}
+SRC_URI="mirror://postgresql/source/v${PV}/${PN}-base-${MY_PV}.tar.bz2
+	mirror://postgresql/source/v${PV}/${PN}-opt-${MY_PV}.tar.bz2
+	doc? ( mirror://postgresql/source/v${PV}/${PN}-docs-${MY_PV}.tar.bz2 )
+	pg-hier? ( http://gppl.moonbone.ru/${P_HIERPG}.diff.gz )"
+
+LICENSE="POSTGRESQL"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~s390 ~sh ~sparc ~x86"
+IUSE="ssl nls python tcltk perl libg++ pam readline xml2 zlib doc selinux kerberos pg-intdatetime pg-hier"
+
+S=${WORKDIR}/${MY_P}
+DEPEND="virtual/libc
+	=dev-db/libpq-8.0.7*
+	sys-devel/autoconf
+	>=sys-libs/ncurses-5.2
+	>=sys-devel/bison-1.875
+	zlib? ( >=sys-libs/zlib-1.1.3 )
+	readline? ( >=sys-libs/readline-4.1 )
+	tcltk? ( >=dev-lang/tcl-8 >=dev-lang/tk-8.3.3-r1 )
+	perl? ( >=dev-lang/perl-5.6.1-r2 )
+	python? ( >=dev-lang/python-2.2 dev-python/egenix-mx-base )
+	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
+	xml2? ( dev-libs/libxml2 dev-libs/libxslt dev-util/pkgconfig )
+	nls? ( sys-devel/gettext )
+	kerberos? ( virtual/krb5 )"
+RDEPEND="virtual/libc
+	=dev-db/libpq-8.0.7*
+	zlib? ( >=sys-libs/zlib-1.1.3 )
+	tcltk? ( >=dev-lang/tcl-8 )
+	perl? ( >=dev-lang/perl-5.6.1-r2 )
+	python? ( >=dev-lang/python-2.2 )
+	selinux? ( sec-policy/selinux-postgresql )
+	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
+	xml2? ( dev-libs/libxml2 dev-libs/libxslt )
+	kerberos? ( virtual/krb5 )"
+
+PG_DIR="/var/lib/postgresql"
+
+pkg_setup() {
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
+		PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
+		if [ ${PG_MAJOR} -lt 8 ] || [ ${PG_MAJOR} -eq 8 -a ${PG_MINOR} -lt 0 ] ; then
+			eerror "Postgres ${MY_PV} cannot upgrade your existing databases, you must"
+			eerror "use pg_dump to export your existing databases to a file, and then"
+			eerror "pg_restore to import them when you have upgraded completely."
+			eerror "You must remove your entire database directory to continue."
+			eerror "(database directory = ${PG_DIR})."
+			exit 1
+		fi
+	fi
+	enewgroup postgres 70 \
+		|| die "problem adding group postgres"
+	enewuser postgres 70 /bin/bash /var/lib/postgresql postgres \
+		|| die "problem adding user postgres"
+}
+
+src_unpack() {
+	unpack ${A} || die
+	cd ${S}
+	use pg-hier && epatch ${WORKDIR}/${P_HIERPG}.diff
+	epatch ${FILESDIR}/${P}-gentoo.patch
+	epatch ${FILESDIR}/${P}-sh.patch
+}
+
+src_compile() {
+	filter-flags -ffast-math -feliminate-dwarf2-dups
+
+	local myconf
+	use tcltk && myconf="--with-tcl"
+	use python && myconf="$myconf --with-python"
+	use perl && myconf="$myconf --with-perl"
+	use ssl && myconf="$myconf --with-openssl"
+	use nls && myconf="$myconf --enable-nls"
+	use libg++ && myconf="$myconf --with-CXX"
+	use pam && myconf="$myconf --with-pam"
+	use readline || myconf="$myconf --without-readline"
+	use zlib || myconf="$myconf --without-zlib"
+	use kerberos && myconf="$myconf --with-krb5"
+	use pg-intdatetime && myconf="$myconf --enable-integer-datetimes"
+
+	# these are the only working CFLAGS I could get on ppc, so locking them
+	# down, anything more aggressive fails (i.e. -mcpu or -Ox)
+	# Gerk - Nov 26, 2002
+	use ppc && CFLAGS="-pipe -fsigned-char"
+
+	# Detect mips systems properly
+	gnuconfig_update
+
+	./configure --prefix=/usr \
+		--mandir=/usr/share/man \
+		--host=${CHOST} \
+		--with-docdir=/usr/share/doc/${PF} \
+		--libdir=/usr/$(get_libdir) \
+		--enable-depend \
+		$myconf || die
+
+	make LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die
+	cd contrib
+	make LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die
+	if use xml2; then
+		cd xml2
+		make LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die
+	fi
+}
+
+src_install() {
+	if use perl; then
+		mv ${S}/src/pl/plperl/Makefile ${S}/src/pl/plperl/Makefile_orig
+		sed -e "s:(INST_DYNAMIC) /usr/lib:(INST_DYNAMIC) ${D}/usr/lib:" \
+			${S}/src/pl/plperl/Makefile_orig > ${S}/src/pl/plperl/Makefile
+		mv ${S}/src/pl/plperl/GNUmakefile ${S}/src/pl/plperl/GNUmakefile_orig
+		sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \
+			${S}/src/pl/plperl/GNUmakefile_orig > ${S}/src/pl/plperl/GNUmakefile
+	fi
+
+	make DESTDIR=${D} LIBDIR=${D}/usr/lib install || die
+#	make DESTDIR=${D} install-all-headers || die
+	cd ${S}/contrib
+	make DESTDIR=${D} LIBDIR=${D}/usr/lib install || die
+	if use xml2; then
+		cd ${S}/contrib/xml2
+		make DESTDIR=${D} LIBDIR=${D}/usr/lib install || die
+	fi
+	cd ${S}
+	dodoc README HISTORY COPYRIGHT INSTALL
+	dodoc contrib/adddepend/*
+
+	exeinto /usr/bin
+
+	cd ${S}/doc
+	dodoc FAQ* README.* TODO bug.template
+	if use doc; then
+		cd ${S}/doc
+		docinto FAQ_html
+		dodoc src/FAQ/*
+		docinto sgml
+		dodoc src/sgml/*.{sgml,dsl}
+		docinto sgml/ref
+		dodoc src/sgml/ref/*.sgml
+		docinto TODO.detail
+		dodoc TODO.detail/*
+	fi
+
+	cd ${S}
+	exeinto /etc/init.d/
+	newexe ${FILESDIR}/postgresql.init-${PV} postgresql || die
+	newexe ${FILESDIR}/pg_autovacuum.init-${PV} pg_autovacuum || die
+	dosed "s:___DOCDIR___:/usr/share/doc/${PF}:" /etc/init.d/pg_autovacuum
+
+	insinto /etc/conf.d/
+	newins ${FILESDIR}/postgresql.conf-${PV} postgresql || die
+	newins ${FILESDIR}/pg_autovacuum.conf-${PV} pg_autovacuum || die
+
+	rm ${D}/usr/include/postgres_ext.h
+}
+
+pkg_postinst() {
+	einfo "Make sure the postgres user in /etc/passwd has an account setup with /bin/bash as the shell"
+
+	if [ ! -f ${PG_DIR}/data/PG_VERSION ] ; then
+		einfo ""
+		einfo "Execute the following command"
+		einfo "emerge --config =${PF}"
+		einfo "to setup the initial database environment."
+		einfo ""
+	fi
+}
+
+pkg_config() {
+	einfo "Creating the data directory ..."
+	mkdir -p ${PG_DIR}/data
+	chown -Rf postgres:postgres ${PG_DIR}
+	chmod 700 ${PG_DIR}/data
+
+	einfo "Initializing the database ..."
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		eerror "Postgres ${MY_PV} cannot upgrade your existing databases."
+		eerror "You must remove your entire database directory to continue."
+		eerror "(database directory = ${PG_DIR})."
+		exit 1
+	else
+		local SEM=`sysctl -n kernel.sem | cut -f-3`
+		local SEMMNI=`sysctl -n kernel.sem | cut -f4`
+		local SEMMNI_MIN=`expr \( ${MAX_CONNECTIONS} + 15 \) / 16`
+		local SHMMAX=`sysctl -n kernel.shmmax`
+		local SHMMAX_MIN=`expr 250000 + 8200 \* 1000 + 14200 \* 100`
+
+		if [ ${SEMMNI} -lt ${SEMMNI_MIN} ]; then
+			eerror "The current value of SEMMNI is too low"
+			eerror "for postgresql to run ${MAX_CONNECTIONS} connections"
+			eerror "Temporary setting this value to ${SEMMNI_MIN} while creating the initial database."
+			echo ${SEM} ${SEMMNI_MIN} > /proc/sys/kernel/sem
+		fi
+		su postgres -c "/usr/bin/initdb --pgdata ${PG_DIR}/data"
+
+		if [ ! `sysctl -n kernel.sem | cut -f4` -eq ${SEMMNI} ] ; then
+			echo ${SEM} ${SEMMNI} > /proc/sys/kernel/sem
+			ewarn "Restoring the SEMMNI value to the previous value"
+			ewarn "Please edit the last value of kernel.sem in /etc/sysctl.conf"
+			ewarn "and set it to at least ${SEMMNI_MIN}"
+			ewarn ""
+			ewarn "  kernel.sem = ${SEM} ${SEMMNI_MIN}"
+			ewarn ""
+		fi
+
+		if [ ${SHMMAX} -lt ${SHMMAX_MIN} ]; then
+			eerror "The current value of SHMMAX is too low for postgresql to run."
+			eerror "Please edit /etc/sysctl.conf and set this value to at least ${SHMMAX_MIN}."
+			eerror ""
+			eerror "  kernel.shmmax = ${SHMMAX_MIN}"
+			eerror ""
+
+		fi
+		einfo ""
+		einfo "You can use /etc/init.d/postgresql script to run PostgreSQL instead of pg_ctl."
+		einfo ""
+	fi
+}