Changeset 7614


Ignore:
Timestamp:
Mar 1, 2019, 1:04:36 PM (3 years ago)
Author:
Nicklas Nordborg
Message:

References #2154: Test BASE with PostgreSQL 11

Updated documentation to recommend PostgreSQL 11 as the database to use. Re-ordered several sections so that PostgreSQL comes before MySQL.

Location:
trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/config/dist/base.config

    r7572 r7614  
    2525# =======================
    2626
     27# ----------------------
     28# Postgres (recommended)
     29# ----------------------
     30db.dialect          = org.hibernate.dialect.PostgreSQL9Dialect
     31db.url              = jdbc:postgresql:base2
     32db.dynamic.schema   = dynamic
     33db.queries          = /postgres-queries.xml
     34
    2735# -----
    2836# MySQL
    2937# -----
    30 db.dialect          = org.hibernate.dialect.MySQL5InnoDBDialect
    31 db.url              = jdbc:mysql://localhost/base2?characterEncoding=UTF-8&useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true
    32 db.dynamic.catalog  = base2dynamic
    33 db.queries          = /mysql-queries.xml
    34 #export.max.items    = 20000
    35 
    36 # --------
    37 # Postgres
    38 # --------
    39 #db.dialect          = org.hibernate.dialect.PostgreSQL9Dialect
    40 #db.url              = jdbc:postgresql:base2
    41 #db.dynamic.schema   = dynamic
    42 #db.queries          = /postgres-queries.xml
     38# db.dialect          = org.hibernate.dialect.MySQL5InnoDBDialect
     39# db.url              = jdbc:mysql://localhost/base2?characterEncoding=UTF-8&useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true
     40# db.dynamic.catalog  = base2dynamic
     41# db.queries          = /mysql-queries.xml
     42
    4343
    4444# -------------
  • trunk/doc/src/docbook/admin/installation.xml

    r7613 r7614  
    5656      </para>
    5757     
    58       <bridgehead>Consider upgrading to Tomcat 9</bridgehead>
     58      <bridgehead>Consider upgrading to Tomcat 9 and PostgreSQL 11</bridgehead>
    5959      <para>
    60         We have started to test BASE with Tomcat 9 and has not found any problems
    61         so far. For new installations we recommend that Tomcat 9 is used. Official
    62         support for Tomcat 8 will be dropped in a future BASE version. For existing
    63         installations our recommendation is to start planning for an upgrade to
    64         Tomcat 9.
     60        We have started to test BASE with Tomcat 9 and PostgreSQL 11 and we have
     61        not found any problems  so far. For new installations we recommend that Tomcat 9
     62        and PostgreSQL 11 is used. Official support for Tomcat 8 and PostgreSQL 9 will be
     63        dropped in a future BASE version. For existing installations our recommendation
     64        is to start planning for an upgrade to Tomcat 9 and PostgreSQL 11.
    6565      </para>
    6666     
     
    301301            object persistence to a relational database. Hibernate
    302302            supports many database engines, but so far we only work
    303             with <ulink url="http://www.mysql.com">MySQL</ulink>
    304             and <ulink
    305             url="http://www.postgresql.org/">PostgreSQL</ulink>.
     303            with <ulink url="http://www.postgresql.org/">PostgreSQL</ulink> (recommended)
     304            and <ulink url="http://www.mysql.com">MySQL</ulink>.
    306305          </para>
    307306
    308307          <variablelist>
     308            <varlistentry>
     309              <term>PostgreSQL</term>
     310              <listitem>
     311                <para>
     312                  PostgreSQL 11 and 9 seems to be working very well with
     313                  BASE and Hibernate. We hve not tested with PostgreSQL 10
     314                  but don't have any reason to believe that it should not work.
     315                  Download and install PostgreSQL, available from
     316                  <ulink url="http://www.postgresql.org/" />. BASE comes
     317                  pre-configured for PostgreSQL so there is no need to change database
     318                  settings in the BASE configuration files.
     319                </para>
     320              </listitem>
     321            </varlistentry>
    309322            <varlistentry>
    310323              <term>MySQL</term>
     
    320333                  (not that you would) but you may want to tune the
    321334                  InnoDB behaviour before creating BASE
    322                   databases. BASE comes pre-configured for MySQL so
    323                   there is no need to change database settings in the
    324                   BASE configuration files.
    325                 </para>
    326               </listitem>
    327             </varlistentry>
    328             <varlistentry>
    329               <term>PostgreSQL</term>
    330               <listitem>
    331                 <para>
    332                   PostgreSQL 9.3 seems to be working very well with
    333                   BASE and Hibernate. Download and install PostgreSQL,
    334                   available from
    335                   <ulink url="http://www.postgresql.org/" />. You must edit
    336                   your <filename>&lt;base-dir&gt;/www/WEB-INF/classes/base.config</filename>
    337                   file. Uncomment the settings for PostgreSQL and
    338                   comment out the settings for MySQL.
     335                  databases.
     336                 
     337                  You must edit your <filename>&lt;base-dir&gt;/www/WEB-INF/classes/base.config</filename>
     338                  file. Uncomment the settings for MySQL and
     339                  comment out the settings for PostgreSQL.
    339340                </para>
    340341              </listitem>
     
    374375          </important>
    375376          <variablelist>
     377            <varlistentry>
     378              <term>PostgreSQL</term>
     379              <listitem>
     380                <para>
     381                  Create a new database for BASE, and add a
     382                  <emphasis>db_user</emphasis> with the proper
     383                  privileges. To do this, log in as your PostgreSQL
     384                  user and issue these lines (omit comments):
     385<programlisting>createuser db_user -P
     386  # this will prompt for an password for the new user, and issue two
     387  # more question that should be answered with character 'n' for no.
     388createdb --owner db_user --encoding UTF8 base2
     389psql base2
     390  # this will start the psql command line tool. Issue the next line
     391  # within the tool and quit with a '\q'.
     392CREATE SCHEMA "dynamic" AUTHORIZATION "db_user";</programlisting>
     393
     394                  If you download BASE (instructions below) you find a file
     395                  <filename>&lt;base-dir&gt;/misc/sql/createdb.postgresql.sql</filename>
     396                  that contains the above statements and can be used
     397                  by the <filename>psql</filename> command-line tool:
     398                  <command>psql -f
     399                  &lt;base-dir&gt;/misc/sql/createdb.posgres.sql
     400                  template1</command> The header in the script file
     401                  contains further information about the script.
     402                </para>
     403              </listitem>
     404            </varlistentry>
    376405            <varlistentry>
    377406              <term>MySQL</term>
     
    404433                  header in the script file contains further
    405434                  information about the script.
    406                 </para>
    407               </listitem>
    408             </varlistentry>
    409             <varlistentry>
    410               <term>PostgreSQL</term>
    411               <listitem>
    412                 <para>
    413                   Create a new database for BASE, and add a
    414                   <emphasis>db_user</emphasis> with the proper
    415                   privileges. To do this, log in as your PostgreSQL
    416                   user and issue these lines (omit comments):
    417 <programlisting>createuser db_user -P
    418   # this will prompt for an password for the new user, and issue two
    419   # more question that should be answered with character 'n' for no.
    420 createdb --owner db_user --encoding UTF8 base2
    421 psql base2
    422   # this will start the psql command line tool. Issue the next line
    423   # within the tool and quit with a '\q'.
    424 CREATE SCHEMA "dynamic" AUTHORIZATION "db_user";</programlisting>
    425 
    426                   If you download BASE (instructions below) you find a file
    427                   <filename>&lt;base-dir&gt;/misc/sql/createdb.postgresql.sql</filename>
    428                   that contains the above statements and can be used
    429                   by the <filename>psql</filename> command-line tool:
    430                   <command>psql -f
    431                   &lt;base-dir&gt;/misc/sql/createdb.posgres.sql
    432                   template1</command> The header in the script file
    433                   contains further information about the script.
    434435                </para>
    435436              </listitem>
     
    16941695              <para>
    16951696              Read the
    1696               <ulink url="http://www.postgresql.org/docs/9.1/interactive/populate.html">http://www.postgresql.org/docs/9.1/interactive/populate.html</ulink>
     1697              <ulink url="https://www.postgresql.org/docs/11/populate.html">https://www.postgresql.org/docs/11/populate.html</ulink>
    16971698              document from the PostgreSQL documentation and consider implementing some
    16981699              of the tips. The migration script makes sure that no indexes or foreign
  • trunk/doc/src/docbook/appendix/update_warnings.xml

    r7613 r7614  
    3939    <title>BASE 3.15</title>
    4040 
    41     <bridgehead>Consider upgrading to Tomcat 9</bridgehead>
    42     <para>
    43       We have started to test BASE with Tomcat 9 and has not found any problems
    44       so far. For new installations we recommend that Tomcat 9 is used. Official
    45       support for Tomcat 8 will be dropped in a future BASE version. For existing
    46       installations our recommendation is to start planning for an upgrade to
    47       Tomcat 9.
     41    <bridgehead>Consider upgrading to Tomcat 9 and PostgreSQL 11</bridgehead>
     42    <para>
     43      We have started to test BASE with Tomcat 9 and PostgreSQL 11 and we have
     44      not found any problems  so far. For new installations we recommend that Tomcat 9
     45      and PostgreSQL 11 is used. Official support for Tomcat 8 and PostgreSQL 9 will be
     46      dropped in a future BASE version. For existing installations our recommendation
     47      is to start planning for an upgrade to Tomcat 9 and PostgreSQL 11.
    4848    </para>
    4949 
Note: See TracChangeset for help on using the changeset viewer.