|
Revision 900, 1.2 kB
(checked in by jalet, 22 years ago)
|
|
Job history added. Upgrade script neutralized for now !
|
-
Property svn:eol-style set to
native
-
Property svn:executable set to
*
-
Property svn:keywords set to
Author Date Id Revision
|
| Line | |
|---|
| 1 | #! /bin/sh |
|---|
| 2 | # $Id$ |
|---|
| 3 | echo WARNING : This is dangerous ! |
|---|
| 4 | echo WARNING : You may loose your PyKota Quota Storage contents. |
|---|
| 5 | echo WARNING : If unsure press Ctrl+C NOW TO STOP, else press ENTER TO PROCEED |
|---|
| 6 | read |
|---|
| 7 | |
|---|
| 8 | echo This script does not work at all yet ! |
|---|
| 9 | echo Please be patient so that I can write a safe upgrade script |
|---|
| 10 | echo of completely drop your existing database to start anew |
|---|
| 11 | echo with this version of PyKota. |
|---|
| 12 | |
|---|
| 13 | #echo -n Update begins... |
|---|
| 14 | #pg_dump -D -N -U postgres -f pykotadb-full.dump pykota >upgrade.messages 2>upgrade.errors |
|---|
| 15 | #pg_dump -a -D -N -U postgres -f pykotadb.dump pykota >>upgrade.messages 2>>upgrade.errors |
|---|
| 16 | #dropdb pykota >>upgrade.messages 2>>upgrade.errors |
|---|
| 17 | #dropuser pykotaadmin >>upgrade.messages 2>>upgrade.errors |
|---|
| 18 | #dropuser pykotauser >>upgrade.messages 2>>upgrade.errors |
|---|
| 19 | #psql -U postgres template1 -f pykota-postgresql.sql >>upgrade.messages 2>>upgrade.errors |
|---|
| 20 | #psql -U postgres pykota -f pykotadb.dump >>upgrade.messages 2>>upgrade.errors |
|---|
| 21 | #echo |
|---|
| 22 | #echo Done ! |
|---|
| 23 | #echo Check the files upgrade.messages and upgrade.errors to see if all is OK. |
|---|
| 24 | #echo NOTICE messages are normal and expected. In case other message types |
|---|
| 25 | #echo are found in upgrade.errors, please file a bug report and restore |
|---|
| 26 | #echo your database from pykotadb-full.dump |
|---|
