Skip to content
Snippets Groups Projects

Update migration documentation

Merged Robbie Luijben requested to merge update-migration-documentation into main
1 unresolved thread

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
53 53
54 54 ## Dump and restore
55 55 On the database server, dump the newly combined table with the correct format and the date in the filename for future reference as follows:
56 > pg_dump -d ldvadmin -U ldvadmin -t lofardata_dataproduct -O > lofardata_fixture_<the_date>.sql
56 > pg_dump -d ldvadmin -U ldvadmin -t lofardata_dataproduct -O > lofardata_fixture_$(date +%d-%m-%y).sql
57
58 After the dump, copy the dumped .sql file to the server where ldvspec is deployed using the SCP command (for production, this is sdc.astron.nl). Subsequently, connect to this server and then to the ldv-spec-postgres docker container, which hosts the ldvspec database.
59
60 Before loading the data into the lofardata_dataproduct table, make sure to login to the database and empty the table:
61
62 > truncate table lofardata_dataproduct;
Please register or sign in to reply
Loading