| 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 |
| | 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 |
