Differences

This shows you the differences between two versions of the page.

--- install:upgrade:4.3.x-to-4.4.0 [2016/03/29 09:25] – [Modules] miconda
+++ install:upgrade:4.3.x-to-4.4.0 [2016/09/07 20:47] (current) – [Postgres Database Structure] giacomo.vacca
@@ Line 34: / Line 34: @@
 The functions for routing blocks are the same, no changes are required there.
 ===== Core =====
 ==== Parameters ====
+=== fork ===
+(INF) This is just heads up notification that the **fork** parameter is planned to be refactored in the next version, because **fork=no** disables many features without explicit visibility (e.g., no tcp/tls, only listening on first network interface). The value **fork=yes** will preserve existing behaviour.
 ===== Database =====
@@ Line 54: / Line 59: @@
 ALTER TABLE active_watchers
   ADD COLUMN flags int(11) NOT NULL DEFAULT '0',
-  ADD COLUMN user_agent varchar(255) NOT NULL;
+  ADD COLUMN user_agent varchar(255) DEFAULT '' NOT NULL;
 DELETE FROM version WHERE TABLE_NAME='active_watchers';
 INSERT INTO version (`table_name`, `table_version`) VALUES ('active_watchers','12');
 -- table: trusted
-ALTER TABLE trusted
+ALTER TABLE `trusted`
   ADD COLUMN priority int(11) NOT NULL DEFAULT '0',
   ADD COLUMN ruri_pattern varchar(64) NULL,
@@ Line 73: / Line 78: @@
 INSERT INTO version (`table_name`, `table_version`) VALUES ('uacreg','2');
+</code>
+==== Postgres Database Structure ====
+Run following SQL statements in psql client to upgrade database structure from v4.3 to v4.4:
+<code sql>
+-- table: active_watchers
+ALTER TABLE active_watchers ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL;
+ALTER TABLE active_watchers ADD COLUMN user_agent VARCHAR(255) DEFAULT '' NOT NULL;
+DELETE FROM version WHERE TABLE_NAME='active_watchers';
+INSERT INTO version (TABLE_NAME, table_version) VALUES ('active_watchers','12');
+-- table: trusted
+ALTER TABLE trusted ADD COLUMN priority INTEGER DEFAULT 0 NOT NULL;
+ALTER TABLE trusted ADD COLUMN ruri_pattern VARCHAR(64) NULL;
+ALTER TABLE trusted ALTER COLUMN tag TYPE VARCHAR(64);
+DELETE FROM version WHERE TABLE_NAME='trusted';
+INSERT INTO version (TABLE_NAME, table_version) VALUES ('trusted','6');
+-- table: uacreg
+ALTER TABLE uacreg ADD COLUMN reg_delay INTEGER DEFAULT 0 NOT NULL;
+ALTER TABLE uacreg ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL;
+DELETE FROM version WHERE TABLE_NAME='uacreg';
+INSERT INTO version (TABLE_NAME, table_version) VALUES ('uacreg','2');
 </code>