Impossible d'utiliser une restauration depuis NodeChef

[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

ERREUR : la relation "public.spatial_ref_sys" n'existe pas

Cette table ne fait pas partie de Discourse, donc je suppose que c’est une spécificité de NodeChef ?

En tout cas, vous devrez modifier votre fichier de sauvegarde et supprimer les données et les références de cette table.

[b481]

D’ailleurs, par curiosité, ils avaient pas mal de plugins préinstallés. Devrai-je les installer sur ma nouvelle construction pour que la sauvegarde fonctionne, ou puis-je les installer après coup ?

[Stephen]

Une restauration ne échouera pas sans eux, mais il est généralement préférable d’avoir tout en place dans votre app.yml avant d’exécuter la restauration.

[b481]

Ma sauvegarde provient également d’une version antérieure, cela va-t-il poser des problèmes ?

[Stephen]

Que voulez-vous dire par version antérieure ? Quelle est son ancienneté ?

[RGJ (Richard - Communiteq)]

@b481

20191209095548

Non, cela ne posera pas de problème, la restauration la mettra automatiquement à jour vers la version actuelle.
Dans ce cas, il est fortement recommandé d’installer les extensions avant de restaurer la sauvegarde.

[b481]

@b481

public.spatial_ref_sys

Je n’ai trouvé qu’une seule occurrence de ceci dans le fichier .sql. J’espère que la suppression des parties surlignées devrait suffire. (Je suppose que le premier fait référence à public.spatial_ref_sys)

Par ailleurs, comment remplacer le fichier dump.sql à l’intérieur du fichier tar.gz par celui modifié ?

[RGJ (Richard - Communiteq)]

@b481

Par ailleurs, comment remplacer le fichier dump.sql à l’intérieur du fichier tar.gz par une version modifiée ?

# Compresser dump.sql et le placer dans le même répertoire que la sauvegarde
gzip dump.sql

# Copier le fichier de sauvegarde vers fixed-* ; remplacez ceci par le nom de votre propre fichier de sauvegarde
cp backupfilename-2020-08-30-123456-v20200830123456.tar.gz fixed-backupfilename-2020-08-30-123456-v20200830123456.tar.gz

# Décompresser
gzip -d fixed-backupfilename-2020-08-30-123456-v20200830123456.tar.gz

# Supprimer le fichier dump.sql.gz original de l'archive.
# Notez que le nom du fichier de sauvegarde ne contient pas .gz à cette étape.
tar f fixed-backupfilename-2020-08-30-123456-v20200830123456.tar --delete dump.sql.gz

# Ajouter le nouveau dump.sql.gz. Notez que le nom du fichier de sauvegarde ne contient pas .gz à cette étape.
tar fr fixed-backupfilename-2020-08-30-123456-v20200830123456.tar dump.sql.gz

# Le recompresser. Notez que le nom du fichier de sauvegarde ne contient pas .gz à cette étape.
gzip fixed-backupfilename-2020-08-30-123456-v20200830123456.tar

[b481]

Merci @RGJ, mon site est de nouveau opérationnel et fonctionne parfaitement. Il ne reste plus qu’à réinstaller quelques plugins.

Merci aussi infiniment à toi @Falco pour m’avoir aidé à identifier le problème dès le départ.