Doesn't seem to be playing nice as a clean install on freebsd with postgres 9.3.
Starting clean, no database or users: root@aox:/var/log # /usr/local/libexec/aox/installer -p pgsql -a 1.2.3.4 Connecting to Postgres server 1.2.3.4 as user pgsql. Creating the 'aox' PostgreSQL user. Creating the 'aoxsuper' PostgreSQL user. Creating the 'archiveopteryx' database. Adding citext to the 'archiveopteryx' database. Loading the database schema. SET SET CREATE TABLE INSERT 0 1 psql:/usr/local/libdata/aox/schema.pg:22: ERROR: extension "citext" already exists Couldn't execute psql. Please re-run the installer after doing the following as user pgsql: psql -h 1.2.3.4 -p 5432 archiveopteryx -f - <<PSQL; \set ON_ERROR_STOP SET SESSION AUTHORIZATION aoxsuper; SET client_min_messages TO 'ERROR'; \i /usr/local/libdata/aox/schema.pg \i /usr/local/libdata/aox/flag-names \i /usr/local/libdata/aox/field-names \i /usr/local/libdata/aox/downgrades PSQL Ok, I can work around that by commenting out line 22 in schema.pg -- it shouldn't try to add the citext extension again since it added it earlier. This lets me create the database and start aox. So I start it up, and it disappears immediately. Logs tell me it's a schema issue. Mar 9 21:07:44 aox Archiveopteryx: 58451/9 The existing schema (revision 95) is older than this server (version 3.2.0) expected (revision 97). Please run 'aox upgrade schema' or contact support. Hmm, why did it install schema 95 out of the box and not 97? Easy enough to fix though, right? root@aox:/var/log # aox upgrade schema aox: PostgreSQL Server: column a.procpid does not exist aox: Upgrading schema from revision 95 to revision 97. aox: 95-96: Convert addresses to use CITEXT. If this fails, please run "CREATE EXTENSION citext;" as the postgres superuser and then rerun aox upgrade schema. aox: Operation would create two identical addresses (addresses_nld_key) aox: 96-97: Dropping aox views. aox: Checking database, adjusting privileges. aox: The schema could not be upgraded to revision 97. aox: The schema could not be upgraded to revision 97. aox: Fatal error. Exiting. I don't know why the schema upgrade is failing, but I do know that in Postgres 9.3 procpid is just called pid now. Any idea how to get a clean install of aox 3.2.0 up and running?
