Mailing List Archive

RFC: PostgreSQL Documentation
-----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: RFC: PostgreSQL Documentation [ In reply to ]
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: RFC: PostgreSQL Documentation [ In reply to ]
-----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: RFC: PostgreSQL Documentation [ In reply to ]
-----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: RFC: PostgreSQL Documentation [ In reply to ]
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: RFC: PostgreSQL Documentation [ In reply to ]
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: RFC: PostgreSQL Documentation [ In reply to ]
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/
Re: RFC: PostgreSQL Documentation [ In reply to ]
-----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-----