Changeset 5867


Ignore:
Timestamp:
Nov 11, 2011, 9:09:37 AM (10 years ago)
Author:
Nicklas Nordborg
Message:

References #1630: Migrate from MySQL to PostgreSQL

Added note about superuser privileges requirement for PostgreSQL.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/doc/src/docbook/admin/installation.xml

    r5865 r5867  
    16661666              so that the BASE installation points to the new database.
    16671667              </para>
     1668             
     1669              <important>
     1670                <para>
     1671                  The PostgreSQL account used to connect to the database server must have
     1672                  <emphasis>superuser</emphasis> privileges during the migration. This is a
     1673                  PostgreSQL requirement when reading data from files. Either use the
     1674                  <code>creauteuser --superuser</code>
     1675                  option when creating the new user, or issue the following SQL command to
     1676                  elevate the user (replace db_user with the actual user account name):
     1677                </para>
     1678               
     1679                <programlisting>alter role "db_user" superuser</programlisting>
     1680                <para>
     1681                  The superuser privileges can be removed after
     1682                  the migration has completed with:
     1683                </para>
     1684                <programlisting>alter role "db_user" nosuperuser</programlisting>
     1685              </important>
    16681686            </listitem>
    16691687         
Note: See TracChangeset for help on using the changeset viewer.