Running into the exact same issue with the migrating from the same provider as here, however this topic has closed, so I may as well make a new one, as I’m at my wits’ end trying to fix this. [image] I can't restore a backup from NodeChef Support I am in the process of moving our Discourse pilot from the (I know unsupported) NodeChef to a VPS on OVH. I created a backup on NodeChef and wanted to restore this backup on the fresh Discourse install on OVH. Now, the upload of the back worked fine, but the Restore button remains greyed out? I have no control over the version on NodeChef (which is at the time of the backup was 2.3.0 beta3 +115) and the new install on the VPS is 2.3.0 beta6 +70. Can I get this backup restored? here’s the log [2020-08-30 02:34:59] [STARTED] [2020-08-30 02:34:59] 'username' has started the restore! [2020-08-30 02:34:59] Marking restore as running... [2020-08-30 02:34:59] Making sure /var/www/discourse/tmp/restores/default/2020-08-30-023459 exists... [2020-08-30 02:34:59] Copying archive to tmp directory... [2020-08-30 02:35:00] Unzipping archive, this may take a while... [2020-08-30 02:35:01] Extracting dump file... [2020-08-30 02:35:07] Validating metadata... [2020-08-30 02:35:07] Current version: 20200820232017 [2020-08-30 02:35:07] Restored version: 20191209095548 [2020-08-30 02:35:07] Enabling readonly mode... [2020-08-30 02:35:07] Pausing sidekiq... [2020-08-30 02:35:07] Waiting up to 60 seconds for Sidekiq to finish running jobs... [2020-08-30 02:35:14] Creating missing functions in the discourse_functions schema... [2020-08-30 02:35:15] Restoring dump file... (this may take a while) [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] set_config [2020-08-30 02:35:15] ------------ [2020-08-30 02:35:15] (1 row) [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] SET [2020-08-30 02:35:15] CREATE TABLE [2020-08-30 02:35:15] CREATE SEQUENCE [2020-08-30 02:35:15] ALTER SEQUENCE [2020-08-30 02:35:15] CREATE TABLE [2020-08-30 02:35:15] CREATE SEQUENCE [2020-08-30 02:35:15] ALTER SEQUENCE [2020-08-30 02:35:15] CREATE TABLE [2020-08-30 02:35:15] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] COMMENT [2020-08-30 02:35:16] COMMENT [2020-08-30 02:35:16] COMMENT [2020-08-30 02:35:16] COMMENT [2020-08-30 02:35:16] COMMENT [2020-08-30 02:35:16] COMMENT [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] COMMENT [2020-08-30 02:35:16] CREATE VIEW [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:16] CREATE TABLE [2020-08-30 02:35:16] CREATE SEQUENCE [2020-08-30 02:35:16] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:17] CREATE SEQUENCE [2020-08-30 02:35:17] ALTER SEQUENCE [2020-08-30 02:35:17] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:18] CREATE SEQUENCE [2020-08-30 02:35:18] ALTER SEQUENCE [2020-08-30 02:35:18] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] CREATE TABLE [2020-08-30 02:35:19] CREATE SEQUENCE [2020-08-30 02:35:19] ALTER SEQUENCE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:19] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] ALTER TABLE [2020-08-30 02:35:20] COPY 0 [2020-08-30 02:35:20] setval [2020-08-30 02:35:20] -------- [2020-08-30 02:35:20] 1 [2020-08-30 02:35:20] (1 row) [2020-08-30 02:35:20] COPY 1 [2020-08-30 02:35:20] setval [2020-08-30 02:35:20] -------- [2020-08-30 02:35:20] 1 [2020-08-30 02:35:20] (1 row) [2020-08-30 02:35:20] COPY 2265 [2020-08-30 02:35:20] setval [2020-08-30 02:35:20] -------- [2020-08-30 02:35:20] 2265 [2020-08-30 02:35:20] (1 row) [2020-08-30 02:35:20] COPY 1 [2020-08-30 02:35:20] COPY 5 [2020-08-30 02:35:20] setval [2020-08-30 02:35:20] -------- [2020-08-30 02:35:20] 6 [2020-08-30 02:35:20] (1 row) [2020-08-30 02:35:20] COPY 3 [2020-08-30 02:35:20] setval [2020-08-30 02:35:20] -------- [2020-08-30 02:35:20] 4 [2020-08-30 02:35:20] (1 row) [2020-08-30 02:35:20] COPY 50 [2020-08-30 02:35:20] setval [2020-08-30 02:35:20] -------- [2020-08-30 02:35:20] 102 [2020-08-30 02:35:20] (1 row) [2020-08-30 02:35:20] COPY 12 [2020-08-30 02:35:20] setval [2020-08-30 02:35:20] -------- [2020-08-30 02:35:20] 18 [2020-08-30 02:35:20] (1 row) [2020-08-30 02:35:20] COPY 0 [2020-08-30 02:35:20] COPY 0 [2020-08-30 02:35:20] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 66 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 42639 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 1 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 2 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 11 [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 2 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 17 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 125 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 60 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 110 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 6 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 11 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 618 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 649 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 7618 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 7650 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 144 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 31927 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 4865 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 14890 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 158 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 173 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 4405 [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 7 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 7 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 277 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 321 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 9 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 40 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 0 [2020-08-30 02:35:21] COPY 1 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 1 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:21] COPY 29 [2020-08-30 02:35:21] setval [2020-08-30 02:35:21] -------- [2020-08-30 02:35:21] 29 [2020-08-30 02:35:21] (1 row) [2020-08-30 02:35:22] COPY 0 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 1 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 1047 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 1047 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 40 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 40 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 0 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 1 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 0 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 1 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 1 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 1 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 25 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 130 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 0 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 1 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 0 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 1 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 28716 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 61999 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 0 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 1 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 37 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 37 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 8862 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 9103 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 2 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 2 [2020-08-30 02:35:22] (1 row) [2020-08-30 02:35:22] COPY 103 [2020-08-30 02:35:22] setval [2020-08-30 02:35:22] -------- [2020-08-30 02:35:22] 115 [2020-08-30 02:35:23] (1 row) [2020-08-30 02:35:23] COPY 123 [2020-08-30 02:35:23] setval [2020-08-30 02:35:23] -------- [2020-08-30 02:35:23] 125 [2020-08-30 02:35:23] (1 row) [2020-08-30 02:35:23] COPY 353 [2020-08-30 02:35:23] COPY 30 [2020-08-30 02:35:23] setval [2020-08-30 02:35:23] -------- [2020-08-30 02:35:23] 30 [2020-08-30 02:35:23] (1 row) [2020-08-30 02:35:23] COPY 7 [2020-08-30 02:35:23] setval [2020-08-30 02:35:23] -------- [2020-08-30 02:35:23] 9 [2020-08-30 02:35:23] (1 row) [2020-08-30 02:35:23] COPY 49237 [2020-08-30 02:35:23] setval [2020-08-30 02:35:23] -------- [2020-08-30 02:35:23] 49417 [2020-08-30 02:35:23] (1 row) [2020-08-30 02:35:23] COPY 1565 [2020-08-30 02:35:23] setval [2020-08-30 02:35:23] -------- [2020-08-30 02:35:23] 1603 [2020-08-30 02:35:23] (1 row) [2020-08-30 02:35:23] COPY 0 [2020-08-30 02:35:23] setval [2020-08-30 02:35:23] -------- [2020-08-30 02:35:23] 1 [2020-08-30 02:35:23] (1 row) [2020-08-30 02:35:23] COPY 13071 [2020-08-30 02:35:23] COPY 0 [2020-08-30 02:35:23] setval [2020-08-30 02:35:23] -------- [2020-08-30 02:35:23] 1 [2020-08-30 02:35:23] (1 row) [2020-08-30 02:35:24] COPY 4480 [2020-08-30 02:35:24] setval [2020-08-30 02:35:24] -------- [2020-08-30 02:35:24] 4513 [2020-08-30 02:35:24] (1 row) [2020-08-30 02:35:25] COPY 29186 [2020-08-30 02:35:25] COPY 29563 [2020-08-30 02:35:25] setval [2020-08-30 02:35:25] -------- [2020-08-30 02:35:25] 29625 [2020-08-30 02:35:25] (1 row) [2020-08-30 02:35:27] COPY 604395 [2020-08-30 02:35:27] COPY 3980 [2020-08-30 02:35:27] setval [2020-08-30 02:35:27] -------- [2020-08-30 02:35:27] 7152 [2020-08-30 02:35:27] (1 row) [2020-08-30 02:35:29] COPY 29578 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 29657 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 0 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 2 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 742 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 775 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 72 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 72 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 0 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 1 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 16 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 16 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 8 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 8 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 8 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 8 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 0 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 1 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 951 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 951 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 951 [2020-08-30 02:35:29] COPY 0 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 1 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 7 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 7 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 0 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 1 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 1124 [2020-08-30 02:35:29] setval [2020-08-30 02:35:29] -------- [2020-08-30 02:35:29] 1124 [2020-08-30 02:35:29] (1 row) [2020-08-30 02:35:29] COPY 0 [2020-08-30 02:35:30] setval [2020-08-30 02:35:30] -------- [2020-08-30 02:35:30] 1 [2020-08-30 02:35:30] (1 row) [2020-08-30 02:35:30] COPY 0 [2020-08-30 02:35:30] setval [2020-08-30 02:35:30] -------- [2020-08-30 02:35:30] 1 [2020-08-30 02:35:30] (1 row) [2020-08-30 02:35:30] COPY 208 [2020-08-30 02:35:30] setval [2020-08-30 02:35:30] -------- [2020-08-30 02:35:30] 1601 [2020-08-30 02:35:30] (1 row) [2020-08-30 02:35:30] COPY 2398 [2020-08-30 02:35:30] setval [2020-08-30 02:35:30] -------- [2020-08-30 02:35:30] 7298 [2020-08-30 02:35:30] (1 row) [2020-08-30 02:35:30] ERROR: relation "public.spatial_ref_sys" does not exist [2020-08-30 02:35:30] EXCEPTION: psql failed: ERROR: relation "public.spatial_ref_sys" does not exist [2020-08-30 02:35:30] /var/www/discourse/lib/backup_restore/database_restorer.rb:95:in `restore_dump' /var/www/discourse/lib/backup_restore/database_restorer.rb:26:in `restore' /var/www/discourse/lib/backup_restore/restorer.rb:49:in `run' /var/www/discourse/lib/backup_restore.rb:188:in `block in start!' /var/www/discourse/lib/backup_restore.rb:185:in `fork' /var/www/discourse/lib/backup_restore.rb:185:in `start!' /var/www/discourse/lib/backup_restore.rb:30:in `restore!' /var/www/discourse/app/controllers/admin/backups_controller.rb:119:in `restore' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/abstract_controller/base.rb:195:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/rendering.rb:30:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/abstract_controller/callbacks.rb:42:in `block in process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/callbacks.rb:112:in `block in run_callbacks' /var/www/discourse/app/controllers/application_controller.rb:340:in `block in with_resolved_locale' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/i18n-1.8.5/lib/i18n.rb:313:in `with_locale' /var/www/discourse/app/controllers/application_controller.rb:340:in `with_resolved_locale' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/callbacks.rb:121:in `block in run_callbacks' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/callbacks.rb:139:in `run_callbacks' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/abstract_controller/callbacks.rb:41:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/rescue.rb:22:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/instrumentation.rb:33:in `block in process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/notifications.rb:180:in `block in instrument' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/notifications/instrumenter.rb:24:in `instrument' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/notifications.rb:180:in `instrument' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/instrumentation.rb:32:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/params_wrapper.rb:245:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.2/lib/active_record/railties/controller_runtime.rb:27:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/abstract_controller/base.rb:136:in `process' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionview-6.0.3.2/lib/action_view/rendering.rb:39:in `process' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.0.4/lib/mini_profiler/profiling_methods.rb:104:in `block in profile_method' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal.rb:190:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal.rb:254:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/route_set.rb:50:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/route_set.rb:33:in `serve' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/mapper.rb:18:in `block in ' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/mapper.rb:48:in `serve' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/journey/router.rb:49:in `block in serve' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/journey/router.rb:32:in `each' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/journey/router.rb:32:in `serve' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/route_set.rb:834:in `call' /var/www/discourse/lib/middleware/omniauth_bypass_middleware.rb:68:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/tempfile_reaper.rb:15:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/conditional_get.rb:40:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/head.rb:12:in `call' /var/www/discourse/lib/content_security_policy/middleware.rb:12:in `call' /var/www/discourse/lib/middleware/anonymous_cache.rb:336:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:266:in `context' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:260:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/cookies.rb:648:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/callbacks.rb:27:in `block in call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/callbacks.rb:101:in `run_callbacks' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/callbacks.rb:26:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/actionable_exceptions.rb:17:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/debug_exceptions.rb:32:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/show_exceptions.rb:33:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/logster-2.9.3/lib/logster/middleware/reporter.rb:43:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/rack/logger.rb:37:in `call_app' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/rack/logger.rb:28:in `call' /var/www/discourse/config/initializers/100-quiet_logger.rb:19:in `call' /var/www/discourse/config/initializers/100-silence_logger.rb:31:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/remote_ip.rb:81:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/request_id.rb:27:in `call' /var/www/discourse/lib/middleware/enforce_hostname.rb:22:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/method_override.rb:24:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/executor.rb:14:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/sendfile.rb:110:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/host_authorization.rb:76:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.0.4/lib/mini_profiler/profiler.rb:321:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/message_bus-3.3.1/lib/message_bus/rack/middleware.rb:61:in `call' /var/www/discourse/lib/middleware/request_tracker.rb:176:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/engine.rb:527:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/railtie.rb:190:in `public_send' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/railtie.rb:190:in `method_missing' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/urlmap.rb:74:in `block in call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/urlmap.rb:58:in `each' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/urlmap.rb:58:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/lib/unicorn/http_server.rb:632:in `process_client' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/lib/unicorn/http_server.rb:728:in `worker_loop' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/lib/unicorn/http_server.rb:548:in `spawn_missing_workers' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/lib/unicorn/http_server.rb:144:in `start' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/bin/unicorn:128:in ` ' /var/www/discourse/vendor/bundle/ruby/2.6.0/bin/unicorn:23:in `load' /var/www/discourse/vendor/bundle/ruby/2.6.0/bin/unicorn:23:in ` ' [2020-08-30 02:35:30] Trying to rollback... [2020-08-30 02:35:30] Rolling back... [2020-08-30 02:35:30] Cleaning stuff up... [2020-08-30 02:35:30] Dropping functions from the discourse_functions schema... [2020-08-30 02:35:30] Removing tmp '/var/www/discourse/tmp/restores/default/2020-08-30-023459' directory... [2020-08-30 02:35:31] Unpausing sidekiq... [2020-08-30 02:35:31] Disabling readonly mode... [2020-08-30 02:35:31] Marking restore as finished... [2020-08-30 02:35:31] Notifying 'username' of the end of the restore...

[image] b481: ERROR: relation "public.spatial_ref_sys" does not exist That table isn’t part of Discourse, so I guess it is a NodeChef thing? Anyway, you will want to edit your backup file and remove data and references from that table.

Also, just curious, they had quite a few plugins pre-installed, will I have to install them on my new build for the backup to work or can I install them afterwards?

A restore won’t fail without them, but it’s usually better to have everything in-place in your app.yml prior to running the restore.

My backup is also from a prior version, will this cause any issues?

What do you mean by prior version? How old is it?

[image] b481: public.spatial_ref_sys I was only able to find one instance of this in the .sql file. Hopefully deleting the highlighted parts should do the trick. (I presume the top one refers to public.spatial_ref_sys) [ye] Also, how does one replace the dump.sql inside the tar.gz file with the modified one?

[image] b481: Also, how does one replace the dump.sql inside the tar.gz file with the modified one? # gzip dump and put it in the same directory as the backup gzip dump.sql # copy backup file to fixed-* , replace this with your own backup file name cp backupfilename-2020-08-30-123456-v20200830123456.tar.gz fixed-backupfilename-2020-08-30-123456-v20200830123456.tar.gz # decompress gzip -d fixed-backupfilename-2020-08-30-123456-v20200830123456.tar.gz # remove original dump.sql.gz from the archive. # Note that the backup filename does not contain .gz in this step. tar f fixed-backupfilename-2020-08-30-123456-v20200830123456.tar --delete dump.sql.gz # add new dump.sql.gz. Note that the backup filename does not contain .gz in this step. tar fr fixed-backupfilename-2020-08-30-123456-v20200830123456.tar dump.sql.gz # compress it again. Note that the backup filename does not contain .gz in this step. gzip fixed-backupfilename-2020-08-30-123456-v20200830123456.tar

thanks @RGJ, my site is now back up and running perfectly. just gotta reinstall some plugins. also thanks a million @Falco for helping me ID the problem in the first place.

Unable to use a restore from NodeChef

Product Support

RGJ (Richard - Communiteq) August 30, 2020, 3:04pm 7

No, that will be ok, the restore will update it automatically to the current version.
In this case, it is strongly recommended to install the plugins prior to restoring the backup though.

Topic		Replies	Views
I can't restore a backup from NodeChef Product Support unsupported-install	11	1239	April 3, 2019
[PAID] Need a backup altered/fixed Marketplace	7	1057	August 31, 2020
Restore has failed. when i backup and restore to a new discourse Product Support	13	1844	September 16, 2019
Error when restore DB backup Self-hosting	25	2253	August 23, 2018
Restore from old version to a new version of discourse failed Self-hosting	16	2792	December 16, 2019

Unable to use a restore from NodeChef

Related topics