What happens if I initdb after syncdb?

fayshaw

I am trying to migrate a cd2 / dap web_logs database from my local machine to a google cloud virtual machine.  I created a postgres dump of the local database, uploaded it to the cloud, and used postgres restore.  Now I am trying to syncdb and get the following error.

✗ ERROR: Operation syncdb failed. Reason: Table not initialized. Please run initdb first.

✗ ERROR: Operation syncdb failed for table web_logs

✗ ERROR: Operation syncdb completed with issues: 1 failed out of 1 table(s).

If I run initdb, will my whole database will get overwritten?

stimme

Does your new postgres database on your cloud machine include the instructure_dap schema? The DAP stores info about table syncing in instructure_dap.table_sync. If it wasn't included in the restore, you could try creating it again.

When you run initdb on a table that exists, I believe you are warned that it exists and advised to run dropdb against the table first. That works well generally when you need to start fresh with a table. But you do not want to do that for canvas_logs.web_logs, because initdb should only get the records for the past 30 days, not all records.