This new documentation for PostgreSQL obsoletes the current documentation on g.o. It is a straightforward installation guide that touches on the Gentoo eccentricities of the new ebuilds. (dev-db/postgresql-{docs,base,server}) It avoids making comparisons between MySQL and PostgreSQL, it does not recommend that users set a password for the 'postgres' system account as that actually poses a security risk, and it leaves guiding users on different database operations -- such as creating a database, roles and tables -- to the official documentation to explain as there are too many details to simply gloss over and the official documentation has a very good tutorial.
Created attachment 241161 [details] PostgreSQL Doc
Created attachment 264045 [details] Reviewed/updated PostgreSQL guide Updated the guide, mainly style and some writing (no real content change though).
I've got to update this guide as there will be some changes that need to be reflected in the doc.
*** Bug 358267 has been marked as a duplicate of this bug. ***
BUG 358267 IS NOT a duplicate. The bug, 330927, is about updating documentation for Version 8.4 of PG. PG 9 is quite different from PG8, You'll most likely need 2 differnent version of the document or a split system where you can follow instructions on the different versions 8 or 9. I have not posted more about specific suggestion, because right now pg( says in installs) OK. Then the instructions say to run: emerge postgresql-server --config that returns this prose "* Initializing the database ... initdb: file "/usr/share/postgresql-8.4/postgres.bki" does not exist This might mean you have a corrupted installation or identified the wrong directory with the invocation option -L. " * You can use the '//etc/init.d/postgresql-9.0' script to run PostgreSQL * instead of 'pg_ctl'. OK so '/etc/init.d/postgresql-9.0 start' returns: postgres cannot access the server configuration file "/var/lib/postgresql/9.0/data/postgresql.conf": No such file or directory I think some basic (current) documentation on PG9 separate from PG8 is warranted, since they are slotted..... hmmmmmmmmmmm?
(In reply to comment #5) No, separate documentation is not required. The details for installing, running and migrating PostgreSQL on Gentoo are consistent between versions with the exception that starting with 9.0 a new tool to make migrations even faster and easier, which can be covered in its own subsection of the documentation. The instructions given by the ebuild to initialize the database is most certainly not: emerge postgresql-server --config As for the error regarding '/usr/share/postgresql-8.4/postgres.bki', that is a separate bug.
I've merged some of the changes that Sven had attached to this bug. You can review the resulting doc at: http://git.overlays.gentoo.org/gitweb/?p=proj/pgsql-patches.git;a=commit;h=f8317be1c97202f4edecef8f21c074cd50843cf8 I still need to go through it a bit more to cover some of the additional changes made in the ebuilds and I should probably mention at some point that 'eselect postgresql' is used to define the default slot to use.
http://git.overlays.gentoo.org/gitweb/?p=proj/pgsql-patches.git;a=shortlog;h=refs/heads/documentation Updated. This revision should be ready to be published.
Thanks, document committed in CVS.