[gentoo-doc] RFC: PostgreSQL Documentation

[gentoo-doc] RFC: PostgreSQL Documentation

[Aaron W. Swenson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

I think the documentation I've written[1] for PostgreSQL is pretty well
set to be published. I'm submitting it here for a final review.

It's intended to replace the existing postgres-howto.xml.

Some items that have been removed from this version of the documentation
from the old one:
  - No comparison to MySQL
  - Does not instruct users to give the 'postgres' system user a
    password (A potential security risk)
  - Does not instruct users in creating a database and/or role (This is
    better left to the official tutorial, which this doc points to)

[1] http://dev.gentoo.org/~titanofold/postgresql.xml

- - Aaron
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iF4EAREIAAYFAk4pc60ACgkQCOhwUhu5AEkqcwD8CIBymIwoEyq2fE0XzW8Mzig2
HkNeAzFFnm7kBMHKmTwA/13grpyqafc4Nb5ouoG9Aszd4RavMoA/YOkrf49gmSEM
=UR79
-----END PGP SIGNATURE-----

Re: [gentoo-doc] RFC: PostgreSQL Documentation

[Sven Vermeulen]

On Fri, Jul 22, 2011 at 08:57:17AM -0400, Aaron W. Swenson wrote:
> I think the documentation I've written[1] for PostgreSQL is pretty well
> set to be published. I'm submitting it here for a final review.
[...] 
> [1] http://dev.gentoo.org/~titanofold/postgresql.xml

Looks good here. Just found a part in the document where you used tabs
instead of spaces, but otherwise ok. Perhaps you can invalidate the
attachments in bug #330927 and also mark #300236 as a duplicate of #330927?

Wkr,
	Sven Vermeulen

Re: [gentoo-doc] RFC: PostgreSQL Documentation

[Aaron W. Swenson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 07/22/2011 11:17 AM, Sven Vermeulen wrote:
> On Fri, Jul 22, 2011 at 08:57:17AM -0400, Aaron W. Swenson wrote:
>> I think the documentation I've written[1] for PostgreSQL is pretty
>> well set to be published. I'm submitting it here for a final
>> review.
> [...]
>> [1] http://dev.gentoo.org/~titanofold/postgresql.xml
> 
> Looks good here. Just found a part in the document where you used
> tabs instead of spaces, but otherwise ok. Perhaps you can invalidate
> the attachments in bug #330927 and also mark #300236 as a duplicate
> of #330927?
> 
> Wkr, Sven Vermeulen
> 

I don't know how those tabs are getting in there. I'll fix it when I get
home tonight.

I've obsoleted those attachments, but 300236 isn't really a duplicate.
Three or four bugs will be fixed when the doc gets placed, so I'll close
it then.

Thanks for reading the doc.

- - Aaron
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iF4EAREIAAYFAk4pwZYACgkQCOhwUhu5AEmM/wD/SyXR6TddZNRQTfGMOON2w5TO
Q6K2EcqIIcRIk59KvCwBAKlxL845ZX245+hPd5dKe631ggUqT1cLXfuE2UYZH0Dy
=DHcG
-----END PGP SIGNATURE-----

Re: [gentoo-doc] RFC: PostgreSQL Documentation

[Aaron W. Swenson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 07/22/2011 02:29 PM, Aaron W. Swenson wrote:
> On 07/22/2011 11:17 AM, Sven Vermeulen wrote:
>> On Fri, Jul 22, 2011 at 08:57:17AM -0400, Aaron W. Swenson wrote:
>>> I think the documentation I've written[1] for PostgreSQL is
>>> pretty well set to be published. I'm submitting it here for a
>>> final review.
>> [...]
>>> [1] http://dev.gentoo.org/~titanofold/postgresql.xml
> 
>> Looks good here. Just found a part in the document where you used 
>> tabs instead of spaces, but otherwise ok. Perhaps you can
>> invalidate the attachments in bug #330927 and also mark #300236 as
>> a duplicate of #330927?
> 
>> Wkr, Sven Vermeulen
> 
> 
> I don't know how those tabs are getting in there. I'll fix it when I
> get home tonight.
> 
> I've obsoleted those attachments, but 300236 isn't really a
> duplicate. Three or four bugs will be fixed when the doc gets placed,
> so I'll close it then.
> 
> Thanks for reading the doc.
> 
> - Aaron
> 

Okay, that's done. I also fixed my email address to be my gentoo.org one.

- - Aaron
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iF4EAREIAAYFAk4q+hwACgkQCOhwUhu5AEmURAD/WOzRKu4ZvWrv0b76izdc/B8v
eZjsPeOzVdG8Y39cr/MBAMT3U88HO1AGAz0j8Cs6nfWpMtP6NSXmriod0m4eprt7
=FRv2
-----END PGP SIGNATURE-----

Re: [gentoo-doc] RFC: PostgreSQL Documentation

[David Abbott]

On Sat, Jul 23, 2011 at 12:43 PM, Aaron W. Swenson
<titanofold@gentoo.org> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> On 07/22/2011 02:29 PM, Aaron W. Swenson wrote:
>> On 07/22/2011 11:17 AM, Sven Vermeulen wrote:
>>> On Fri, Jul 22, 2011 at 08:57:17AM -0400, Aaron W. Swenson wrote:
>>>> I think the documentation I've written[1] for PostgreSQL is
>>>> pretty well set to be published. I'm submitting it here for a
>>>> final review.
<p>
At this point you are ready to continue on with the official <uri
src="http://www.postgresql.org/docs/current/static/tutorial.html">PostgreSQL
Tutorial</uri>. The tutorial will guide you through creating roles, databases,
schemata and all that fun and useful stuff.
</p>
s/src/link
Currently it points to;
http://dev.gentoo.org/~titanofold/PostgreSQL%0ATutorial

Regards,
David

-- 
David Abbott (dabbott)
Gentoo
http://dev.gentoo.org/~dabbott/

Re: [gentoo-doc] RFC: PostgreSQL Documentation

[David Abbott]

On Fri, Jul 22, 2011 at 8:57 AM, Aaron W. Swenson <titanofold@gentoo.org> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> I think the documentation I've written[1] for PostgreSQL is pretty well
> set to be published. I'm submitting it here for a final review.
>
Also This section;
<p>
You can change your locale and encoding selections at database creation time
(<uri
link="http://www.postgresql.org/docs/current/static/sql-createdatabase.html"><c>CREATE
DATABASE</c></uri>). In order to change the locale for a database after you have
created it, you must drop the database and start over again.
</p>
The c tags can't be inside the uri tag;

postgresql.xml:410: element uri: validity error : Element c is not
declared in uri list of possible children
DATABASE</c></uri>). In order to change the locale for a database after you have

I would change it so it reads a little clearer to somethin like;

<p>
You can change your locale and encoding selections at database <uri
  link="http://www.postgresql.org/docs/current/static/sql-createdatabase.html">creation
  time.</uri>). In order to change the locale for a database after you have
created it, you must drop the database and start over again.
</p>

Regards,
David
-- 
David Abbott (dabbott)
Gentoo
http://dev.gentoo.org/~dabbott/

Re: [gentoo-doc] RFC: PostgreSQL Documentation

[David Abbott]

[-- Attachment #1: Type: text/plain, Size: 1698 bytes --]

On Sat, Jul 23, 2011 at 3:44 PM, David Abbott <dabbott@gentoo.org> wrote:
> On Fri, Jul 22, 2011 at 8:57 AM, Aaron W. Swenson <titanofold@gentoo.org> wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA256
>>
>> I think the documentation I've written[1] for PostgreSQL is pretty well
>> set to be published. I'm submitting it here for a final review.
>>
> Also This section;
> <p>
> You can change your locale and encoding selections at database creation time
> (<uri
> link="http://www.postgresql.org/docs/current/static/sql-createdatabase.html"><c>CREATE
> DATABASE</c></uri>). In order to change the locale for a database after you have
> created it, you must drop the database and start over again.
> </p>
> The c tags can't be inside the uri tag;
>
> postgresql.xml:410: element uri: validity error : Element c is not
> declared in uri list of possible children
> DATABASE</c></uri>). In order to change the locale for a database after you have
>
> I would change it so it reads a little clearer to somethin like;
>
> <p>
> You can change your locale and encoding selections at database <uri
>  link="http://www.postgresql.org/docs/current/static/sql-createdatabase.html">creation
>  time.</uri>). In order to change the locale for a database after you have
> created it, you must drop the database and start over again.
> </p>
I forgot to remove the ). after </uri>

I would also remove this section;
</body>
</section>
<section>
<title>Initialize</title>
<body>

<p>
To finish the installation:
</p>

I attached a diff from yours to the changes I made.
Regards,
David
-- 
David Abbott (dabbott)
Gentoo
http://dev.gentoo.org/~dabbott/

[-- Attachment #2: postgresql.xml.diff --]
[-- Type: text/plain, Size: 1308 bytes --]

--- postgresql.old.xml	2011-07-23 15:50:41.000000000 -0400
+++ postgresql.xml	2011-07-23 15:45:22.000000000 -0400
@@ -404,21 +404,10 @@
 </p>
 
 <p>
-You can change your locale and encoding selections at database creation time
-(<uri
-link="http://www.postgresql.org/docs/current/static/sql-createdatabase.html"><c>CREATE
-DATABASE</c></uri>). In order to change the locale for a database after you have
-created it, you must drop the database and start over again.
-</p>
-
-</body>
-</section>
-<section>
-<title>Initialize</title>
-<body>
-
-<p>
-To finish the installation:
+You can change your locale and encoding selections at database <uri
+  link="http://www.postgresql.org/docs/current/static/sql-createdatabase.html">creation
+  time.</uri> In order to change the locale for a database after you have
+created it, you must drop the database and start over again.  
 </p>
 
 <pre caption="Finalize the installation">
@@ -625,7 +614,7 @@
 
 <p>
 At this point you are ready to continue on with the official <uri
-src="http://www.postgresql.org/docs/current/static/tutorial.html">PostgreSQL
+link="http://www.postgresql.org/docs/current/static/tutorial.html">PostgreSQL
 Tutorial</uri>. The tutorial will guide you through creating roles, databases,
 schemata and all that fun and useful stuff.
 </p>

Re: [gentoo-doc] RFC: PostgreSQL Documentation

[Aaron W. Swenson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 07/23/2011 03:56 PM, David Abbott wrote:
> On Sat, Jul 23, 2011 at 3:44 PM, David Abbott <dabbott@gentoo.org>
> wrote:
>> On Fri, Jul 22, 2011 at 8:57 AM, Aaron W. Swenson
>> <titanofold@gentoo.org> wrote:
>>> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
>>> 
>>> I think the documentation I've written[1] for PostgreSQL is
>>> pretty well set to be published. I'm submitting it here for a
>>> final review.
>>> 
>> Also This section; <p> You can change your locale and encoding
>> selections at database creation time (<uri 
>> link="http://www.postgresql.org/docs/current/static/sql-createdatabase.html"><c>CREATE
>>
>> 
DATABASE</c></uri>). In order to change the locale for a database after
you have
>> created it, you must drop the database and start over again. </p> 
>> The c tags can't be inside the uri tag;
>> 
>> postgresql.xml:410: element uri: validity error : Element c is not 
>> declared in uri list of possible children DATABASE</c></uri>). In
>> order to change the locale for a database after you have
>> 
>> I would change it so it reads a little clearer to somethin like;
>> 
>> <p> You can change your locale and encoding selections at database
>> <uri 
>> link="http://www.postgresql.org/docs/current/static/sql-createdatabase.html">creation
>>
>> 
time.</uri>). In order to change the locale for a database after you have
>> created it, you must drop the database and start over again. </p>
> I forgot to remove the ). after </uri>
> 
> I would also remove this section; </body> </section> <section> 
> <title>Initialize</title> <body>
> 
> <p> To finish the installation: </p>
> 
> I attached a diff from yours to the changes I made. Regards, David
Thanks. Committed.

- - Aaron
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iF4EAREIAAYFAk4rLIkACgkQCOhwUhu5AEkpuQEAhq4wV+MhZ2jIp4JMqDWz+DrX
9LLMXzffJ05dIGk5/YIBAIAIeBJz9MC8NocLtIT4kk5iJB9dSlvRyKhQkARA8dUI
=rjFi
-----END PGP SIGNATURE-----