Greetings Arnt & co: i upgraded aox to the latest git master (commit b247a8506fe9625796a185cb9fd2e9ef6c5fe908 from October 2) and had to make a small adjustment to get the schema upgraded from revision 95 to 96.
the postgresql command "create extension citext" specified in db/schema.cpp must run as a postgresql superuser, or it will fail. i manually performed "create extension citext" on the postgresql database as a postgresql superuser, after which the schema upgrade still failed with: # /usr/local/archiveopteryx/bin/aox upgrade schema aox: PostgreSQL Server: column a.procpid does not exist aox: Upgrading schema from revision 95 to revision 96. aox: 95-96: Convert addresses to use CITEXT aox: PostgreSQL Server: extension "citext" already exists aox: Checking database, adjusting privileges. aox: The schema could not be upgraded to revision 96. aox: The schema could not be upgraded to revision 96. aox: Fatal error. Exiting. modifying db/schema.cpp to add "if not exists" in the sql command to create the citext extension allowed the schema upgrade to proceed: - d->t->enqueue( "create extension citext" ); + d->t->enqueue( "create extension if not exists citext" ); # /usr/local/archiveopteryx/bin/aox upgrade schema aox: PostgreSQL Server: column a.procpid does not exist aox: Upgrading schema from revision 95 to revision 96. aox: 95-96: Convert addresses to use CITEXT [[ long wait ]] aox: Checking database, adjusting privileges. aox: Please run 'aox reparse' (or 'aox reparse -e') when Archiveopteryx has been started. There are 1 unparsed messages now. aox: Schema upgraded to revision 96. hth --sean On Thu, Oct 10, 2013 at 2:29 AM, Arnt Gulbrandsen <[email protected]> wrote: > What happened was that I upgraded the host and fat-fingered a part of > the database. Pure sloppiness on my part. > > I upgraded in order to run the very latest version of aox (which > requires postgres 9.1, hence the upgrade), which I plan to release as > aox 3.2.0 in a few weeks. I do not plan to write any more code, only > watch the logs and when I'm happy, change the version number. Code > review and testing would be welcome. > > Arnt > -- http://durak.org/sean/
