annotate UPGRADING @ 247:70fae534b83a

fixed getItems select in pgsql_storage
author Goffi <goffi@goffi.org>
date Thu, 31 May 2012 00:24:20 +0200
parents cc4f45ef793e
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
208
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
1 Upgrading
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
2 =========
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
3
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
4 To 0.8.0
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
5 ========
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
6
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
7 This release includes an optional HTTP interface with a gateway to subscribe
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
8 to remote nodes. The subscriptions and associated callbacks are stored in
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
9 the database if the PostgreSQL storage backend is used. This requires a new
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
10 table, of which the schema is in db/gateway.sql:
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
11
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
12 psql -e pubsub <db/gateway.sql
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
13
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
14 The schema of the other tables has also changed significantly compared to
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
15 0.7.3 and older. For these changes, there is an upgrade script in the form
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
16 of a series of SQL statements to be run against an database with the older schema: db/to_idavoll_0.8.sql, like so:
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
17
cc4f45ef793e Commit 0.8.1 release to SVN.
Ralph Meijer <ralphm@ik.nu>
parents:
diff changeset
18 psql -e pubsub <db/to_idavoll_0.8.sql