| 1 |
commit: 8e4c5ff3874a008e2832983612525179af5a7e6c |
| 2 |
Author: Aaron W. Swenson <titanofold <AT> gentoo <DOT> org> |
| 3 |
AuthorDate: Sun Apr 3 12:03:07 2011 +0000 |
| 4 |
Commit: Aaron Swenson <titanofold <AT> gentoo <DOT> org> |
| 5 |
CommitDate: Sun Apr 3 12:03:07 2011 +0000 |
| 6 |
URL: http://git.overlays.gentoo.org/gitweb/?p=proj/pgsql-patches.git;a=commit;h=8e4c5ff3 |
| 7 |
|
| 8 |
Tweaked a bit here and there. |
| 9 |
|
| 10 |
--- |
| 11 |
postgresql.xml | 42 +++++++++++++++++++++++------------------- |
| 12 |
1 files changed, 23 insertions(+), 19 deletions(-) |
| 13 |
|
| 14 |
diff --git a/postgresql.xml b/postgresql.xml |
| 15 |
index 5ab1044..73eb974 100644 |
| 16 |
--- a/postgresql.xml |
| 17 |
+++ b/postgresql.xml |
| 18 |
@@ -40,6 +40,11 @@ adhere to the SQL standards and to be more secure, by default, than any other |
| 19 |
database, commercial or otherwise. |
| 20 |
</p> |
| 21 |
|
| 22 |
+<p> |
| 23 |
+Visit the <uri link="http://www.postgresql.org/about/">About</uri> page on |
| 24 |
+postgresql.org for more information. |
| 25 |
+</p> |
| 26 |
+ |
| 27 |
</body> |
| 28 |
</section> |
| 29 |
<section> |
| 30 |
@@ -85,9 +90,9 @@ your migration now. |
| 31 |
<body> |
| 32 |
|
| 33 |
<p> |
| 34 |
-The PostgreSQL ebuilds in Portage feature slotting based on the major version. |
| 35 |
-This allows you to have two major versions of PostgreSQL operating |
| 36 |
-simultaneously; 8.4 and 9.0 libraries and servers can be installed and server at |
| 37 |
+The PostgreSQL ebuilds in Portage feature slotting based on the major version. |
| 38 |
+This allows you to have two major versions of PostgreSQL operating |
| 39 |
+simultaneously; 8.4 and 9.0 libraries and servers can be installed and serve at |
| 40 |
the same time. This is useful in such circumstances where you need to move data |
| 41 |
from an older database to a new database, or need to have a production and a |
| 42 |
testing database on the same machine. Also, this prevents a database, |
| 43 |
@@ -115,11 +120,11 @@ Versioning Policy</uri> for more information. |
| 44 |
<body> |
| 45 |
|
| 46 |
<p> |
| 47 |
-There is quite a bit that will not be covered. The <uri |
| 48 |
-link="http://www.postgresql.org/docs/">official documentation</uri> is somewhere |
| 49 |
-in the neighborhood of 2,000 pages. So, a lot of details will be left out in |
| 50 |
-this quick start guide. Only Gentoo specific issues will be covered and some |
| 51 |
-basic configuration guidelines. |
| 52 |
+There is quite a bit that will not be covered. If the <uri |
| 53 |
+link="http://www.postgresql.org/docs/">official documentation</uri> were to be |
| 54 |
+printed out on 8½x11 paper, it would be somewhere in the neighborhood of 2,000 |
| 55 |
+pages. So, a lot of details will be left out in this quick start guide. Only |
| 56 |
+Gentoo specific issues will be covered and some basic configuration guidelines. |
| 57 |
</p> |
| 58 |
|
| 59 |
</body> |
| 60 |
@@ -414,7 +419,7 @@ To finish the installation: |
| 61 |
</p> |
| 62 |
|
| 63 |
<pre caption="Finalize the installation"> |
| 64 |
-# <i>emerge --config =dev-db/postgresql-server:9.0</i> |
| 65 |
+# <i>emerge --config dev-db/postgresql-server:9.0</i> |
| 66 |
</pre> |
| 67 |
|
| 68 |
<p> |
| 69 |
@@ -433,8 +438,8 @@ into <e>DATA_DIR</e>. |
| 70 |
<body> |
| 71 |
|
| 72 |
<p> |
| 73 |
-This time the focus is upon the files in the <e>PGDATA</e> directory |
| 74 |
-<path>/etc/postgresql-8.4</path> instead with primary focus on the |
| 75 |
+This time the focus is upon the files in the <e>PGDATA</e> directory, |
| 76 |
+<path>/etc/postgresql-9.0</path>, instead with primary focus on the |
| 77 |
<path>postgresql.conf</path> and <path>pg_hba.conf</path> files. |
| 78 |
</p> |
| 79 |
|
| 80 |
@@ -647,9 +652,9 @@ another, <e>e.g.</e>, from PostgreSQL 8.4.7 to 9.0.3, but not from 9.0.2 to |
| 81 |
</p> |
| 82 |
|
| 83 |
<note> |
| 84 |
-You will need to migrate your database when you move from the obsolete Ebuilds |
| 85 |
+You will need to migrate your database when you move from the obsolete ebuilds |
| 86 |
— dev-db/libpq, dev-db/postgresql, dev-db/postgresql-libs, and |
| 87 |
-dev-db/postgresql-client — to the new Ebuilds — |
| 88 |
+dev-db/postgresql-client — to the new ebuilds — |
| 89 |
dev-db/postgresql-docs, dev-db/postgresql-base and dev-db/postgresql-server. |
| 90 |
</note> |
| 91 |
|
| 92 |
@@ -766,7 +771,7 @@ server that contains precisely the same data, bit for bit, as the old server. |
| 93 |
|
| 94 |
<p> |
| 95 |
You will need to schedule some downtime for your server. The old ebuilds |
| 96 |
-<b>cannot</b> be installed at the same time as the new Ebuilds. As such, assume |
| 97 |
+<b>cannot</b> be installed at the same time as the new ebuilds. As such, assume |
| 98 |
that the server will have to be down for a few hours. Maybe for the weekend, |
| 99 |
even. |
| 100 |
</p> |
| 101 |
@@ -792,10 +797,9 @@ server.) |
| 102 |
</pre> |
| 103 |
|
| 104 |
<p> |
| 105 |
-You may break some packages that were built against those ancient packages, but |
| 106 |
-once you have installed dev-db/postgresql-base and/or dev-db/postgresql-server |
| 107 |
-you can run <c>revdep-rebuild</c> to reemerge any packages that may have been |
| 108 |
-broken. |
| 109 |
+You may break some packages that were built against those packages, but once you |
| 110 |
+have installed dev-db/postgresql-base and/or dev-db/postgresql-server you can |
| 111 |
+run <c>revdep-rebuild</c> to reemerge any packages that may have been broken. |
| 112 |
</p> |
| 113 |
|
| 114 |
</body> |
| 115 |
@@ -831,7 +835,7 @@ command: |
| 116 |
</p> |
| 117 |
|
| 118 |
<pre caption="Command to Add Instrumentation Functions"> |
| 119 |
-# <i>psql -U postgres --file /usr/share/postgresql-8.4/contrib/adminpack.sql</i> |
| 120 |
+# <i>psql -U postgres --file /usr/share/postgresql-9.0/contrib/adminpack.sql</i> |
| 121 |
</pre> |
| 122 |
|
| 123 |
</body> |
Archives