| 55 | | a pre-1.01 PyKota version, then please launch the above |
| 56 | | procedure but with the pykota-upgrade-postgresql.sql script |
| 57 | | instead of the pykota-postgresql.sql script. |
| | 55 | a pre-1.01 PyKota version, then please launch the following |
| | 56 | commands : |
| | 57 | |
| | 58 | - Launch the psql frontend and connect to the |
| | 59 | database pykota as a PostgreSQL administrator |
| | 60 | (i.e. the postgres user) : |
| | 61 | |
| | 62 | $ psql -h localhost -U postgres pykota |
| | 63 | |
| | 64 | - Executes the pykota-upgrade-postgresql.sql script : |
| | 65 | |
| | 66 | pykota=# \i pykota-upgrade-postgresql.sql |
| | 67 | |
| | 68 | - Quit the psql frontend : |
| | 69 | |
| | 70 | pykota=# \q |
| | 71 | |
| | 72 | - Your PostgreSQL PyKota storage is now ready |
| | 73 | for use. |
| | 77 | |
| | 78 | WARNING : |
| | 79 | |
| | 80 | This script requires a recent version of PostgreSQL to run |
| | 81 | successfully, because it requires the ALTER TABLE DROP COLUMN |
| | 82 | syntax to be supported. However in case you've got an older |
| | 83 | version, upgrading PostgreSQL is not mandatory, you will just |
| | 84 | have two unused fields in the grouppquota table, these |
| | 85 | fields are pagecounter and lifepagecounter, just forgot them. |
