From 365342d80e6089935d0c977936c2cd36526c8ded Mon Sep 17 00:00:00 2001 From: einhverfr Date: Sun, 22 Apr 2007 18:48:10 +0000 Subject: Committing David Bandel's corrections git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1095 4979c152-3d1c-0410-bac9-87ea11338e46 --- UPGRADE | 22 +++++++++++++++++----- 1 file changed, 17 insertions(+), 5 deletions(-) diff --git a/UPGRADE b/UPGRADE index 54be665a..c4e0e00f 100644 --- a/UPGRADE +++ b/UPGRADE @@ -2,7 +2,7 @@ Upgrading to LedgerSMB 1.2 From LedgerSMB (1.1.1 or earlier) or -SQL-Ledger (2.6.19 or earlier) +SQL-Ledger (2.6.27 or earlier) This document contains information on how to upgrade from earlier versions of LedgerSMB or SQL-Ledger. This upgrade is a major revision and may not go @@ -61,10 +61,22 @@ and may not be required in all circumstances. These include: d) Run the SQL upgrade scripts in order starting with the one whose name begins with "Pg-upgrade-[version]" (each of these scripts will upgrade to the next database version which is also identified in the file name). - -Note that this will create three tables that may not actually be used depending -on your setup: users, users_conf, and session. In general if you have multiple -datasets, these tables will only be used in one. + N.B.: use `ls -v` to see the scripts in version order and run them + in the order shown by this command. + e) If you have a problem running the scripts (errors due to ownership + or you just want to change ownership of the tables), connect to the + database as you did in c above and at the => prompt: + "/d" + You will see a list of all tables, sequences, triggers, etc. After + creating a user (see the INSTALL file for details), you can change + ownership of the relation by running the following at the => prompt: + "ALTER TABLE|SEQUENCE|TRIGGER public. OWNER TO "new_owner"; + Select the appropriate relation type and relation_name. + Rerun the upgrade scripts starting with the first one that failed. + +Note that subpara d above will create three tables that may not actually be +used depending on your setup: users, users_conf, and session. In general if +you have multiple datasets, these tables will only be used in one. 4) Decide where to put the user/session management tables. In general, we recommend as follows: -- cgit v1.2.3