Feature #1490
Feature #1478: write the "Runtime Installation, Configuration and Administration Guide"
cleanup/improve the "Database Setup" chapter
0%
History
#1 Updated by Greg Shah almost 12 years ago
Please cleanup/improve the database_setup.odt chapter in the p2j_docs/runtime_installation_configuration_and_administration_guide/ project. The chapter has good content but it needs LOTS of work. See my many GES: notes in this chapter for details. You should also change or add anything else that you find would be useful.
#2 Updated by Costin Savin almost 12 years ago
- Status changed from New to WIP
#3 Updated by Costin Savin almost 12 years ago
Which version of PostgreeSQL should be documented? from instructions it seems 9.1 or higher.
#4 Updated by Eric Faulhaber almost 12 years ago
Correct, the target going forward is PostgreSQL 9.1 or higher. For H2, it should be 1.3.x or higher.
#5 Updated by Costin Savin almost 12 years ago
The building PL/Java section from Developer Guide specifies that version 1.4.2 could not be compiled with Java 1.6 and needed to extract sourcecode with tag Java6.
Tried to compile PL/Java 1.4.3 and it sais it can only be compiled with java 1.4 or 1.5.
The latest snapshot(2012-05-25) however compiles fine with java 1.6 (that probably means that versions higher than 1.4.3 can be compiled with java 1.6)
What version should be mentioned as default?
#6 Updated by Eric Faulhaber almost 12 years ago
We want to compile with Java 6 or higher and for PostgreSQL 9.1 or higher. I believe the latest version of PL/Java is designed to do both. If that is higher than 1.4.3, but has no release version number assigned yet, please specify (as you have above), versions later than 1.4.3 (and give the 2012-05-25 snapshot as an example).
#7 Updated by Costin Savin almost 12 years ago
Two parameters from Production Configuration postgresql.conf : stats_block_level and stats_row_level (regarding statistics collection of block and row level) don't appear anymore in the PostgreSQL 9.1 User Manual documentation and seem to have merged into track_counts (According to release notes) which is also turned on by default (in the document they were off and changed to on).
Do these entries still make sense?
#8 Updated by Eric Faulhaber almost 12 years ago
I was not aware of the stats_* changes. Since track_counts is on my default, I guess there is no reason to mention these entries anymore.
#9 Updated by Costin Savin almost 12 years ago
"- add a connection security section to this document; here are some important points to consider: we don't yet support encrypted connections but PostgreSQL does support it; if encrypted connections are needed changes will have to be made to <ask_eric_for_a_high_level_list_of_changes>; we use 1 user/database account for all the shared hibernate connections; you should not use the “trust” method of connection security in production environments; make pg_hba.conf parameter recommendations here"
What would the list of changes for this section be?