Kann NodeChef-Wiederherstellung nicht verwenden

[b481]

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

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 <class:Constraints>'
/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 `<top (required)>'
/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 `<main>'
[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...

[Falco]

@b481

ERROR: relation "public.spatial_ref_sys" does not exist

Diese Tabelle gehört nicht zu Discourse, also handelt es sich wohl um eine NodeChef-Sache?

Wie auch immer: Du solltest deine Sicherungsdatei bearbeiten und Daten sowie Verweise aus dieser Tabelle entfernen.

[b481]

Außerdem, nur aus Neugier: Es waren ziemlich viele Plugins vorinstalliert. Muss ich sie auf meinem neuen Build installieren, damit die Sicherung funktioniert, oder kann ich sie später nachinstallieren?

[Stephen]

Eine Wiederherstellung schlägt ohne sie nicht fehl, aber es ist in der Regel besser, alle erforderlichen Elemente in Ihrer app.yml vor der Ausführung der Wiederherstellung bereitzustellen.

[b481]

Mein Backup stammt ebenfalls von einer früheren Version. Wird dies Probleme verursachen?

[Stephen]

Was meinen Sie mit vorheriger Version? Wie alt ist sie?

[RGJ (Richard - Communiteq)]

@b481

20191209095548

Nein, das ist in Ordnung, die Wiederherstellung aktualisiert sie automatisch auf die aktuelle Version.
In diesem Fall wird jedoch dringend empfohlen, die Plugins vor der Wiederherstellung der Sicherungskopie zu installieren.

[b481]

@b481

public.spatial_ref_sys

Ich konnte dies in der .sql-Datei nur an einer Stelle finden. Hoffentlich reicht es, die hervorgehobenen Teile zu löschen. (Ich gehe davon aus, dass sich der obige Eintrag auf public.spatial_ref_sys bezieht.)

Außerdem: Wie ersetzt man die dump.sql-Datei innerhalb der tar.gz-Datei durch die modifizierte Version?

[RGJ (Richard - Communiteq)]

@b481

Außerdem, wie ersetzt man die dump.sql innerhalb der tar.gz-Datei durch die modifizierte Version?

# dump komprimieren und im gleichen Verzeichnis wie das Backup ablegen
gzip dump.sql

# Backup-Datei in fixed-* kopieren, ersetzen Sie dies durch Ihren eigenen Backup-Dateinamen
cp backupfilename-2020-08-30-123456-v20200830123456.tar.gz fixed-backupfilename-2020-08-30-123456-v20200830123456.tar.gz

# decomprimieren
gzip -d fixed-backupfilename-2020-08-30-123456-v20200830123456.tar.gz

# ursprüngliche dump.sql.gz aus dem Archiv entfernen.
# Beachten Sie, dass der Backup-Dateiname in diesem Schritt kein .gz enthält.
tar f fixed-backupfilename-2020-08-30-123456-v20200830123456.tar --delete dump.sql.gz

# neue dump.sql.gz hinzufügen. Beachten Sie, dass der Backup-Dateiname in diesem Schritt kein .gz enthält.
tar fr fixed-backupfilename-2020-08-30-123456-v20200830123456.tar dump.sql.gz

# erneut komprimieren. Beachten Sie, dass der Backup-Dateiname in diesem Schritt kein .gz enthält.
gzip fixed-backupfilename-2020-08-30-123456-v20200830123456.tar

[b481]

Danke @RGJ, meine Seite läuft jetzt wieder einwandfrei. Ich muss nur noch ein paar Plugins neu installieren.

Und auch ein riesiges Dankeschön an @Falco, der mir geholfen hat, das Problem überhaupt zu finden.