Changeset bcdfc53 for server/databases

Timestamp:

12/04/2021 11:16:54 AM (2 years ago)

Author:

Thomas Trepl (Moody) <thomas@…>

Branches:

11.1, 11.2, 11.3, 12.0, 12.1, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, lazarus, lxqt, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal

Children:

7f6bf79b

Parents:

edd2feb7

Message:

Add some notes about upgrading DBMS

Location:

server/databases

Files:

• databases.xml (modified) (1 diff)
• postgresql.xml (modified) (2 diffs)
• upgradedb.xml (added)

server/databases/databases.xml

@@ -19 +19 @@
   </para>
 
+  <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="upgradedb.xml"/>
+
   <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="db.xml"/>
   <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="lmdb.xml"/>

server/databases/postgresql.xml

@@ -167 +167 @@
     </para>
 
+    <note>
+      <para>Hold off from continuing in case you are building 
+      <application>PostgreSQL</application> to upgrade an existing
+      installation. In case the major version of the new build is 
+      different to the existing one, its quite likely that the
+      new software cannot act on the existing data files. In this case,
+      the server will not start and the old binaries has been overwritten
+      so you got stuck with an unusable database.</para>
+      <para>At this moment, you have both, the old and the new binaries
+      on disk. They can be used to perform an upgrade of your existing
+      database right now. For the folloging instructions it is
+      assumed that
+      <itemizedlist>
+        <listitem><para>The actual data files are stored in
+          <filename class="directory">/srv/pgsql/data</filename></para>
+        </listitem>
+        <listitem><para>The upgraded data files will be stored in
+          <filename class="directory">/srv/pgsql/newdata</filename></para>
+        </listitem>
+        <listitem><para>There is enough disk space to hold the actual
+          data files twice. The upgrade is not an inline upgrade but
+          it will copy the data to new database files.</para>
+        </listitem>
+      </itemizedlist>
+      </para>
+
+      <para>Do a temporary install which makes access to the new
+      binaries a bit easier:</para>
+      <screen><userinput>make DESTDIR=$(pwd)/DESTDIR install</userinput></screen>
+
+      <para>Create a directory which is writable by the
+      <systemitem class="username">postgres</systemitem> as the
+      <systemitem class="username">root</systemitem> user:</para>
+      
+      <screen><userinput role="root">install -D -o postgres $(pwd)/DESTDIR/tmp</userinput></screen>
+      
+      <para>Now, stop the existing instance of <application>PostgreSQL</application>
+      and start the upgrade process as the
+      <systemitem class="username">root</systemitem> user:</para>
+      
+      <screen><userinput role="root">pushd $(pwd)/DESTDIR/tmp
+/etc/rc.d/init.d/postgresql stop
+su postgres -c "../usr/bin/initdb -D /srv/pgsql/newdata"
+su postgres -c "../usr/bin/pg_upgrade -d /srv/pgsql/data -D /srv/pgsql/newdata -b /usr/bin -B ../usr/bin"
+popd</userinput></screen>
+      
+      <para>At this stage, you have your database files two times on
+      disk, one is the old data in <filename class="directory">/srv/pgsql/data</filename>
+      and the new ones in <filename class="directory">/srv/pgsql/newdata</filename>.
+      May this is the time you do a last backup of the old database files.</para>
+      
+      <para>Remove the old database files, and rename the new data 
+      directory as the <systemitem class="username">root</systemitem> user:</para>
+      
+      <screen><userinput role="root">rm -rf /srv/pgsql/data
+mv /srv/pgsql/newdata /srv/pgsql/data</userinput></screen>
+
+    </note>
+    
     <para>
       Now, as the <systemitem class="username">root</systemitem> user:
@@ -188 +247 @@
       </para>
     </tip>
+
+    <para>
+      If you have upgraded an existing database, skip the rest of the
+      commands because your database is ready to use. If this is the
+      first time you install <application>PostgreSQL</application>,
+      continue with the initialization.
+    </para>
 
     <para>