I run in the newest version 1.0.0 (for both old and new, but maybe they are use different ruby version, now I am on 2.0.0-p195, since the newest version 2.1.2 can’t work for discourse), It seems work perfect after the (totally) reinstall, except that I can’t restore the backups which are, of course, backed up by the older program. And the error reads:
<supress some code> [Invalid date] CREATE INDEX [Invalid date] CREATE INDEX [Invalid date] CREATE INDEX [Invalid date] Enabling readonly mode... [Invalid date] Pausing sidekiq... [Invalid date] Waiting for sidekiq to finish running jobs... [Invalid date] Switching schemas... [Invalid date] EXCEPTION: PG::Error: ERROR: syntax error at or near "NOT" LINE 7: CREATE SCHEMA IF NOT EXISTS backup; ^ : BEGIN; DO $$DECLARE row record; BEGIN -- create <destination> schema if it does not exists already -- NOTE: DROP & CREATE SCHEMA is easier, but we don't want to drop the public schema -- ortherwise extensions (like hstore & pg_trgm) won't work anymore... CREATE SCHEMA IF NOT EXISTS backup; -- move all <source> tables to <destination> schema FOR row IN SELECT tablename FROM pg_tables WHERE schemaname = 'public' LOOP <supress some code>
I tested that, I can backup and restore by the program running now.
Please help me out here!