nightmorph 07/04/25 07:40:11 Modified: postgres-howto.xml Log: updated postgresql guide for bug 174255
Revision Changes Path 1.4 xml/htdocs/doc/en/postgres-howto.xml file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/postgres-howto.xml?rev=1.4&view=markup plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/postgres-howto.xml?rev=1.4&content-type=text/plain diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/postgres-howto.xml?r1=1.3&r2=1.4 Index: postgres-howto.xml =================================================================== RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/postgres-howto.xml,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- postgres-howto.xml 10 Apr 2007 07:16:49 -0000 1.3 +++ postgres-howto.xml 25 Apr 2007 07:40:11 -0000 1.4 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE guide SYSTEM "/dtd/guide.dtd"> -<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/postgres-howto.xml,v 1.3 2007/04/10 07:16:49 nightmorph Exp $ --> +<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/postgres-howto.xml,v 1.4 2007/04/25 07:40:11 nightmorph Exp $ --> <guide link="/doc/en/postgres-howto.xml" lang="en"> <title>PostgreSQL Guide</title> @@ -22,8 +22,8 @@ <!-- See http://creativecommons.org/licenses/by-sa/2.5 --> <license/> -<version>1.1</version> -<date>2006-04-10</date> +<version>1.2</version> +<date>2007-04-25</date> <chapter> <title>Introduction</title> @@ -159,7 +159,7 @@ <ti> If this option is enabled, <c>XPATH</c> style xml support will be built. More information on using xml support with PostgreSQL can be found on: - <uri link="http://www.throwingbeans.org/tech/postgresql_and_xml.html";> + <uri link="http://www.throwingbeans.org/postgresql_and_xml.html";> PostgreSQL and XML</uri>. </ti> </tr> @@ -326,10 +326,10 @@ <p> The database was successfully created, and we can confirm that the database can run basic tasks. We'll go ahead and drop this database (remove it) with the -<c>dropdb</c> command, creating a new one for usage later on: +<c>dropdb</c> command: </p> -<pre caption="Droping a database with dropdb"> +<pre caption="Dropping a database with dropdb"> $ <i>dropdb -U postgres -W test</i> Password: DROP DATABASE @@ -387,8 +387,8 @@ Success! Our new user was created using the previously created superuser. The <c>-A</c> and <c>-D</c> options do the opposite of <c>-a</c> and <c>-d</c>, and instead deny the user the ability to create other users and databases. Now that -there are users to work with, and a new database created, the next chapter will -look at using the new database. +there are users to work with, the next chapter will look at using the new +database. </p> </body> @@ -401,15 +401,14 @@ <body> <p> -With the new database created, there is a user that can create databases and -add other users, and the main postgres user that can do anything. The user -created earlier can currently login to the server, and that's about it. In -general, users need to be able to insert data and retrieve data, and sometimes -any other number of tasks. So, for this new user to be able to do anything, -they must be setup with the proper permissions. This can easily be done by -passing the <c>-O</c> parameter to <c>createdb</c>. We'll start by making a -new database, <b>MyDB</b> with our superuser that will be owned by the previous -testuser: +Now there is a user that can create databases and add other users, and the main +postgres user that can do anything. The user created earlier can currently login +to the server, and that's about it. In general, users need to be able to insert +data and retrieve data, and sometimes any other number of tasks. So, for this +new user to be able to do anything, they must be setup with the proper +permissions. This can easily be done by passing the <c>-O</c> parameter to +<c>createdb</c>. We'll start by making a new database, <b>MyDB</b> with our +superuser that will be owned by the previous testuser: </p> <pre caption="Creating the MyDB database"> @@ -704,10 +703,10 @@ <p> This concludes the PostgreSQL Guide. A big thanks goes to Masatomo Nakano, the -Gentoo PostgreSQL maintainer for his help in answering my questions. Any -suggestions on this guide should be sent to <mail>[EMAIL PROTECTED]</mail>. -For more extensive documentation, see the <uri -link="http://www.postgresql.org";>PostgreSQL website</uri>. +previous Gentoo PostgreSQL maintainer for his help in answering my questions. +Any suggestions on this guide should be sent to +<mail>[EMAIL PROTECTED]</mail>. For more extensive documentation, see the +<uri link="http://www.postgresql.org";>PostgreSQL website</uri>. </p> </body> -- [EMAIL PROTECTED] mailing list
