|
Revision 888, 1.0 kB
(checked in by jalet, 21 years ago)
|
|
As always I've forgotten to add the file into the CVS tree...
|
-
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 | echo -n Update begins... |
|---|
| 8 | pg_dump -D -N -U postgres -f pykotadb-full.dump pykota >update.messages 2>update.errors |
|---|
| 9 | pg_dump -a -D -N -U postgres -f pykotadb.dump pykota >>update.messages 2>>update.errors |
|---|
| 10 | dropdb pykota >>update.messages 2>>update.errors |
|---|
| 11 | dropuser pykotaadmin >>update.messages 2>>update.errors |
|---|
| 12 | dropuser pykotauser >>update.messages 2>>update.errors |
|---|
| 13 | psql -U postgres template1 -f pykota-postgresql.sql >>update.messages 2>>update.errors |
|---|
| 14 | psql -U postgres pykota -f pykotadb.dump >>update.messages 2>>update.errors |
|---|
| 15 | echo |
|---|
| 16 | echo Done ! |
|---|
| 17 | echo Check the files update.messages and update.errors to see if all is OK. |
|---|
| 18 | echo NOTICE messages are normal and expected. In case other message types |
|---|
| 19 | echo are found in update.errors, please file a bug report and restore |
|---|
| 20 | echo your database from pykotadb-full.dump |
|---|
