jamesstout

0. Assumptions

• You've installed Xdebug in your VM.
• You've installed Xdebug extension for VSCode and reloaded/restarted VSCode.
• You have not forwarded port 9000 from the guest to the host.
• Configure Debugger in VSCode. See item 1 next.

1. Configure .vscode/launch.json

kmatt

pg_dump database -Fc backup.dump
pg_restore -l backup.dump | sed '/MATERIALIZED VIEW DATA/d' > restore.lst
pg_restore -L restore.lst -d database backup.dump

pg_restore -l backup.dump | grep 'MATERIALIZED VIEW DATA' > refresh.lst
pg_restore -L refresh.lst -d database backup.dump

danallison

function downloadString(text, fileType, fileName) {
  var blob = new Blob([text], { type: fileType });

  var a = document.createElement('a');
  a.download = fileName;
  a.href = URL.createObjectURL(blob);
  a.dataset.downloadurl = [fileType, a.download, a.href].join(':');
  a.style.display = "none";
  document.body.appendChild(a);
  a.click();