Changeset 951

Timestamp:

04/23/03 16:20:22 (22 years ago)

Author:

jalet

Message:

The upgrade script now uses TCP/IP for the connection on localhost to PostgreSQL.
Please modify the script to access to a remote PostgreSQL server during the upgrade.

Location:

pykota/trunk/initscripts

Files:

• README (modified) (1 diff)
• README.postgresql (modified) (1 diff)
• upgrade-from-before-1.03.py (modified) (1 diff)

pykota/trunk/initscripts/README

@@ -38 +38 @@
     This file upgrades the PostgreSQL Quota Storage Database schema
     from versions before 1.01 to version 1.01.
-    DON'T USE IT IF YOU ALREADY RUN A POST-1.01 PyKota VERSION.
+    
+    IT'S THERE FOR HISTORICAL REASONS ONLY : DON'T USE IT, USE
+    THE SCRIPT DESCRIBED BELOW INSTEAD !
     
   * upgrade-from-before-1.03.py :

pykota/trunk/initscripts/README.postgresql

@@ -57 +57 @@
   
 * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to 
-  1.01 is included. If your PyKota version is equal or higher than 1.01 then
-  you can skip to the next section. Otherwise, if you want to keep your datas
-  from a pre-1.01 PyKota version, then please launch the following commands : 
+  1.01 is still included for historical reasons. PLEASE DON'T USE IT ! 
   
-        - Launch the psql frontend and connect to the
-          database pykota as a PostgreSQL administrator
-          (i.e. the postgres user) :
-          
-            $ psql -h localhost -U postgres pykota
-          
-        - Executes the pykota-upgrade-postgresql.sql script :  
-        
-            pykota=# \i VERYOLDpykota-upgrade-postgresql.sql
-            
-        - Quit the psql frontend :    
-        
-            pykota=# \q
-            
-        - Your PostgreSQL PyKota storage is now ready
-          for use for the next step, i.e. upgrade the
-          database schema to version 1.03. PLEASE
-          TAKE ANY STEPS DESCRIBED IN THE NEXT SECTION.
-  
-  If you already run PyKota v1.01 or above, you don't need
-  to run this upgrade script.
-  
-  WARNING :  
-
-  This script requires a recent version of PostgreSQL to run
-  successfully, because it requires the ALTER TABLE DROP COLUMN
-  syntax to be supported. However in case you've got an older
-  version, upgrading PostgreSQL is not mandatory, you will just 
-  have two unused fields in the grouppquota table, these
-  fields are pagecounter and lifepagecounter, just forgot them.
-  
-* If you are already running PyKota 1.01 or 1.02 and want to upgrade to 
-  1.03, YOU HAVE TO RUN the upgrade-from-before-1.03.py shell script.
-  NOT LAUNCHING THIS SCRIPT WILL CAUSE PYKOTA TO STOP WORKING !
-  PLEASE NEVER RUN THIS SCRIPT IF YOUR EXISTING VERSION OF PYKOTA IS 
-  ALREADY 1.03 OD HIGHER.
+* If you are already running an old version of PyKota (<1.03) and 
+  want to upgrade to 1.03, YOU HAVE TO RUN the 
+  upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT 
+  WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF 
+  YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OD HIGHER. 

pykota/trunk/initscripts/upgrade-from-before-1.03.py

@@ -57 +57 @@
     """Returns the database object or None if we can't connect to it."""
     try :
-        pykotadb = pg.connect(dbname, user="postgres")
+        pykotadb = pg.connect(host="localhost", port=5432, dbname=dbname, user="postgres")
     except pg.error, msg :     
         sys.stderr.write("%s\n" % msg)
+        sys.stderr.write("Unable to connect to the local PostgreSQL server.\nPlease modify the open_database() method in %s\nto connect to the correct PostgreSQL server\nand relaunch the script.\n" % sys.argv[0])
         return 
     else :