1 |
nightmorph 07/04/25 07:40:11 |
2 |
|
3 |
Modified: postgres-howto.xml |
4 |
Log: |
5 |
updated postgresql guide for bug 174255 |
6 |
|
7 |
Revision Changes Path |
8 |
1.4 xml/htdocs/doc/en/postgres-howto.xml |
9 |
|
10 |
file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/postgres-howto.xml?rev=1.4&view=markup |
11 |
plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/postgres-howto.xml?rev=1.4&content-type=text/plain |
12 |
diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/postgres-howto.xml?r1=1.3&r2=1.4 |
13 |
|
14 |
Index: postgres-howto.xml |
15 |
=================================================================== |
16 |
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/postgres-howto.xml,v |
17 |
retrieving revision 1.3 |
18 |
retrieving revision 1.4 |
19 |
diff -u -r1.3 -r1.4 |
20 |
--- postgres-howto.xml 10 Apr 2007 07:16:49 -0000 1.3 |
21 |
+++ postgres-howto.xml 25 Apr 2007 07:40:11 -0000 1.4 |
22 |
@@ -1,6 +1,6 @@ |
23 |
<?xml version="1.0" encoding="UTF-8"?> |
24 |
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd"> |
25 |
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/postgres-howto.xml,v 1.3 2007/04/10 07:16:49 nightmorph Exp $ --> |
26 |
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/postgres-howto.xml,v 1.4 2007/04/25 07:40:11 nightmorph Exp $ --> |
27 |
|
28 |
<guide link="/doc/en/postgres-howto.xml" lang="en"> |
29 |
<title>PostgreSQL Guide</title> |
30 |
@@ -22,8 +22,8 @@ |
31 |
<!-- See http://creativecommons.org/licenses/by-sa/2.5 --> |
32 |
<license/> |
33 |
|
34 |
-<version>1.1</version> |
35 |
-<date>2006-04-10</date> |
36 |
+<version>1.2</version> |
37 |
+<date>2007-04-25</date> |
38 |
|
39 |
<chapter> |
40 |
<title>Introduction</title> |
41 |
@@ -159,7 +159,7 @@ |
42 |
<ti> |
43 |
If this option is enabled, <c>XPATH</c> style xml support will be built. |
44 |
More information on using xml support with PostgreSQL can be found on: |
45 |
- <uri link="http://www.throwingbeans.org/tech/postgresql_and_xml.html"> |
46 |
+ <uri link="http://www.throwingbeans.org/postgresql_and_xml.html"> |
47 |
PostgreSQL and XML</uri>. |
48 |
</ti> |
49 |
</tr> |
50 |
@@ -326,10 +326,10 @@ |
51 |
<p> |
52 |
The database was successfully created, and we can confirm that the database can |
53 |
run basic tasks. We'll go ahead and drop this database (remove it) with the |
54 |
-<c>dropdb</c> command, creating a new one for usage later on: |
55 |
+<c>dropdb</c> command: |
56 |
</p> |
57 |
|
58 |
-<pre caption="Droping a database with dropdb"> |
59 |
+<pre caption="Dropping a database with dropdb"> |
60 |
$ <i>dropdb -U postgres -W test</i> |
61 |
Password: |
62 |
DROP DATABASE |
63 |
@@ -387,8 +387,8 @@ |
64 |
Success! Our new user was created using the previously created superuser. The |
65 |
<c>-A</c> and <c>-D</c> options do the opposite of <c>-a</c> and <c>-d</c>, and |
66 |
instead deny the user the ability to create other users and databases. Now that |
67 |
-there are users to work with, and a new database created, the next chapter will |
68 |
-look at using the new database. |
69 |
+there are users to work with, the next chapter will look at using the new |
70 |
+database. |
71 |
</p> |
72 |
|
73 |
</body> |
74 |
@@ -401,15 +401,14 @@ |
75 |
<body> |
76 |
|
77 |
<p> |
78 |
-With the new database created, there is a user that can create databases and |
79 |
-add other users, and the main postgres user that can do anything. The user |
80 |
-created earlier can currently login to the server, and that's about it. In |
81 |
-general, users need to be able to insert data and retrieve data, and sometimes |
82 |
-any other number of tasks. So, for this new user to be able to do anything, |
83 |
-they must be setup with the proper permissions. This can easily be done by |
84 |
-passing the <c>-O</c> parameter to <c>createdb</c>. We'll start by making a |
85 |
-new database, <b>MyDB</b> with our superuser that will be owned by the previous |
86 |
-testuser: |
87 |
+Now there is a user that can create databases and add other users, and the main |
88 |
+postgres user that can do anything. The user created earlier can currently login |
89 |
+to the server, and that's about it. In general, users need to be able to insert |
90 |
+data and retrieve data, and sometimes any other number of tasks. So, for this |
91 |
+new user to be able to do anything, they must be setup with the proper |
92 |
+permissions. This can easily be done by passing the <c>-O</c> parameter to |
93 |
+<c>createdb</c>. We'll start by making a new database, <b>MyDB</b> with our |
94 |
+superuser that will be owned by the previous testuser: |
95 |
</p> |
96 |
|
97 |
<pre caption="Creating the MyDB database"> |
98 |
@@ -704,10 +703,10 @@ |
99 |
|
100 |
<p> |
101 |
This concludes the PostgreSQL Guide. A big thanks goes to Masatomo Nakano, the |
102 |
-Gentoo PostgreSQL maintainer for his help in answering my questions. Any |
103 |
-suggestions on this guide should be sent to <mail>chriswhite@g.o</mail>. |
104 |
-For more extensive documentation, see the <uri |
105 |
-link="http://www.postgresql.org">PostgreSQL website</uri>. |
106 |
+previous Gentoo PostgreSQL maintainer for his help in answering my questions. |
107 |
+Any suggestions on this guide should be sent to |
108 |
+<mail>chriswhite@g.o</mail>. For more extensive documentation, see the |
109 |
+<uri link="http://www.postgresql.org">PostgreSQL website</uri>. |
110 |
</p> |
111 |
|
112 |
</body> |
113 |
|
114 |
|
115 |
|
116 |
-- |
117 |
gentoo-doc-cvs@g.o mailing list |