# Unable to use a restore from NodeChef **URL:** https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444 **Category:** Support **Tags:** unsupported-install **Created:** [August 30, 2020, 2:54am UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444 "2020-08-30T02:54:09Z") **Posts on this page:** 10 **Page:** 1
### Author: ![b481](https://avatars.discourse-cdn.com/v4/letter/b/a9adbd/32.png) [@b481](https://meta.discourse.org/u/b481) #### Post date: [August 30, 2020, 2:54am UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/1 "2020-08-30T02:54:09Z")
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. > [@I can't restore a backup from NodeChef](https://meta.discourse.org/t/i-cant-restore-a-backup-from-nodechef/113175): > > 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... ``` ---
### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco) #### Post date: [August 30, 2020, 3:12am UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/2 "2020-08-30T03:12:28Z")
> [@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. ---
### Author: ![b481](https://avatars.discourse-cdn.com/v4/letter/b/a9adbd/32.png) [@b481](https://meta.discourse.org/u/b481) #### Post date: [August 30, 2020, 1:44pm UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/3 "2020-08-30T13:44:28Z")
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? ---
### Author: ![Stephen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/stephen/32/95011_2.png) [@Stephen](https://meta.discourse.org/u/Stephen) #### Post date: [August 30, 2020, 2:08pm UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/4 "2020-08-30T14:08:40Z")
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. ---
### Author: ![b481](https://avatars.discourse-cdn.com/v4/letter/b/a9adbd/32.png) [@b481](https://meta.discourse.org/u/b481) #### Post date: [August 30, 2020, 2:16pm UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/5 "2020-08-30T14:16:45Z")
My backup is also from a prior version, will this cause any issues? ---
### Author: ![Stephen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/stephen/32/95011_2.png) [@Stephen](https://meta.discourse.org/u/Stephen) #### Post date: [August 30, 2020, 2:57pm UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/6 "2020-08-30T14:57:05Z")
What do you mean by prior version? How old is it? ---
### Author: ![RGJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rgj/32/523185_2.png) [@RGJ](https://meta.discourse.org/u/RGJ) #### Post date: [August 30, 2020, 3:04pm UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/7 "2020-08-30T15:04:27Z")
> [@b481](#): > > `20191209095548` 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. ---
### Author: ![b481](https://avatars.discourse-cdn.com/v4/letter/b/a9adbd/32.png) [@b481](https://meta.discourse.org/u/b481) #### Post date: [August 30, 2020, 10:50pm UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/8 "2020-08-30T22:50:49Z")
> [@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](https://global.discourse-cdn.com/meta/original/3X/2/0/20dc7f3727667d7faae4d14e40de6422c639c163.png) Also, how does one replace the dump.sql inside the tar.gz file with the modified one? ---
### Author: ![RGJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rgj/32/523185_2.png) [@RGJ](https://meta.discourse.org/u/RGJ) #### Post date: [August 30, 2020, 11:03pm UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/9 "2020-08-30T23:03:00Z")
> [@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 ``` ---
### Author: ![b481](https://avatars.discourse-cdn.com/v4/letter/b/a9adbd/32.png) [@b481](https://meta.discourse.org/u/b481) #### Post date: [August 31, 2020, 12:03am UTC](https://meta.discourse.org/t/unable-to-use-a-restore-from-nodechef/162444/10 "2020-08-31T00:03:03Z")
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.